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
TOTALYTD for prior Year in Power Pivot Excel
![](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)
Arafat, Yeasin
1
Reputation point
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
Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Excel | For business | Windows
3 answers
Sort by: Most helpful
-
![](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)
Herbert Seidenberg 1,196 Reputation points2022-11-20T16:33:01.817+00:00 -
Arafat, Yeasin 1 Reputation point
2022-11-21T05:39:21.557+00:00 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 -
Herbert Seidenberg 1,196 Reputation points
2022-11-22T00:03:20.953+00:00 Justify
-
Arafat, Yeasin 1 Reputation point
2022-11-22T05:54:05.76+00:00 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 -
Arafat, Yeasin 1 Reputation point
2022-11-22T05:55:06.877+00:00 
Check this
-
Herbert Seidenberg 1,196 Reputation points
2022-11-22T18:01:56.927+00:00 Post link to your *.xlsx file that reflects image.png.
-
Arafat, Yeasin 1 Reputation point
2022-11-27T16:33:22.837+00:00 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
Sign in to comment -
-
Arafat, Yeasin 1 Reputation point
2022-12-01T10:24:10.473+00:00 Any one please help me with this? Thanks in advance
-
Ashish Mathur 99,575 Reputation points Volunteer Moderator2025-07-27T02:07:13.1266667+00:00 Hi,
Write this measure
YTD_SHIP_PY:=CALCULATE([YTD_SHIP_CY],SAMEPERIODLASTYEAR('Calendar'[Date]))