Forum Discussion

nankerp's avatar
nankerp
Helper III
7 years ago
Solved

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?

  • nankerp's avatar
    nankerp
    7 years ago

    Hi,

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

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community 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

    • nankerp's avatar
      nankerp
      Helper III

      Hi,

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