Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors