Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Year to date SUM until today





i have 2 question

a. i created a dax as follow

Total YTD saving = TOTALYTD(SUM(Saving[Actual]),'date'[Date])
it work fine.
but when put into visualization it show like (pict1)
what i want is the visualization will show only until today months, let say today show until september, so October - December will be blank.  i cant put a slicer by month, because i need to see the december data for forecast vs target (in picture color dark blue and yellow)
b. because i can't put my month slicer, when i use DAX to calculate same period last year, it will show last period until december 2018. how to add filter on DAX, so the same period last year always show up to today date regardless of date.
Last year saving = CALCULATE([Total YTD saving],SAMEPERIODLASTYEAR('date'[Date]))
YTD Visualization.JPG
Not applicable



Refer this Article for YTD Calculations.


Best Regards,
Vignesh M

If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue 🙂


Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors