This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 41%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAY%3C/text%3E%3C/svg%3E)
Hi,
Need help calculating Prior Year TOTALYTD.
I am able to calculate the current year TOTALYTD but for the prior year it's not coming as like the current year TOTALYTD it's giving prior year single month total.
using this for current year --- YTD_SHIP_CY:=TOTALYTD([SHIPMENT_GROSS],DATESYTD('Calendar'[Date]))
Tried this for Prior year --- YTD_SHIP_PY:=CALCULATE([SHIPMENT_GROSS],SAMEPERIODLASTYEAR('Calendar'[Date])) Or PREVIOUSYEAR
Both formulas give the same result not giving YTD Total.
Someone, please help me.
Thanks
Yeasin Arafat
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 99%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Excel 365 Pro Plus with Power Pivot and Power Query.
YTD per month and year.
https://www.mediafire.com/file/lkw5tk8xqdko6ru/10_29_22.xlsx/file
https://www.mediafire.com/file/jfe09wowshf9fjk/10_29_22.pdf/file
Hi
Thanks for your reply. YTD formula I can do that but I want to create two measures. One measure will show the current year's TOTALYTD and another one will show the prior year's TOTALYTD. I don't want to use the year field in the pivot table column.
Thanks
Yeasin
Justify
Hi
I'm preparing an excel dashboard where I add many measures in a row so if I put the Year in the column (Pivot table) then it will change the full view and the value of other measures. If possible please help me.
Thanks
Yeasin Arafat
Check this
Post link to your *.xlsx file that reflects image.png.
Hi ,
Sorry, I can't share my excel it has confidential data about my company. If possible please give solution as I ask.
Thanks
Yeasin Arafat
Any one please help me with this? Thanks in advance