Forum Discussion
nankerp
7 years agoHelper III
Quick Measure - TOTALYTD - Not working
Do I need a special Calender to show TOTALYTD in a graph? I have to change the measure to TOTALYTD(SUM('Liste'[Beløp]); dimKalender[Date]) instead of TOTALYTD(SUM('Liste'[Beløp]); 'dimKalender'[Date].[Date]) that was made of the quick measure.
Are there something I do wrong here?
Hi,
The datatype is date. It looks like it works when I mark the calender as datetable.
2 Replies
- v-yuta-msftCommunity Support
Hi nankerp,
What's the data type are there in your column 'dimKalender'[Date]? Is the data format like yyyyMMdd? If not, you'd bettern format your date column into the standard date format.
Regards,
Jimmy Tao
- nankerpHelper III
Hi,
The datatype is date. It looks like it works when I mark the calender as datetable.