Quick Measure - TOTALYTD - Not working

[nankerp]

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?

[v-yuta-msft]

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

[nankerp · Accepted solution]

Hi,

The datatype is date. It looks like it works when I mark the calender as datetable.