YTD comparison of different years

[burna]

I want to calculate , YTD sales for 2015,2016,2017 .Can anyone tell me how to write a DAX query for that  ? I have the data for gross earnings per month  for each of the above year 

[TomMartens · Accepted solution]

Hey,

in this example pbix file there is an example. Have a look at the report page "YTD TimeIntelligence". Within the table "FactWithDates" there is this measure "YTD Amount"

YTD Amount = 
CALCULATE(
	TOTALYTD(SUM(FactWithDates[Amount]),'Calendar'[Date])
)

Please be aware that this measure assumes that there is a separate Calendar table, that is related to the fact table. If you don't have a separate calendar table you should consider to create one, as most of the DAX Time Intelligence functions in DAX just work if there is no missing date value in the column used as parameter.

This link also provides additional examples regarding time relevant calculations

http://www.daxpatterns.com/time-patterns/

Hope this gets you started

Regards

[burna]

Thanks ,that was helpful .Got my desired result 🙂