Forum Discussion
Solved
Time Intelligence not working for me
There must be someting I'm missing here. I can manually do the following to get YTD and it works on my data. That is it resets the total for each year etc. I would like to do a "TOTALYTD" version but...
Thanks, this gets me moving forward. I wish DAX wasn't so fussy.
For example, for the calculated table formula. You used the successful
Date = CALENDAR(MIN(system[AlarmTime]),MAX(system[AlarmTime]))
And I had the not working following which DAX likes to put in when I type in the expression.
Date = CALENDAR(MIN(system[AlarmTime].[Date]),MAX(system[AlarmTime].[Date]))
Also I see the relationships are critical from the date table to my date fields. I note that the relationship is between a date time column and a date column. I guess DAX figures this out.
Thanks
You are welcome.