YTD based on slicer in matrix

[Anonymous]

Hi

I currently have this formula to calculate YTD , however this means that I have to change the date in the formula every time i want to change the month.

Is there a measure i can create which provides me the YTD value, based on the month that is selected on my slicer? I have a column in the table which is a date.

SC YTD = TOTALYTD(sum(Append1[Actual/Forecast]),DATESBETWEEN(Append1[Date],DATE(2019,01,01),DATE(2019,03,31)))

Thanks in advance!

[v-joesh-msft · Accepted solution]

Hi @Anonymous ,

You can create a Date table: Date = CALENDARAUTO()

Then create a measure like this:

SC YTD = CALCULATE(SUM(Append1[Actual/Forecast])),DATESYTD('Date'[Date]))

Results are as follows:

Here is a demo, please try it：

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/Ed5ioHwnWD9FvTvdswEVjboBy2q37oGg55WdUKVsApa1Wg?e=e6T0kN

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.