Forum Discussion
TOTALMTD not returning a value
Hi bjones,
As you mentioned in original post, the date is 'yyyy/MM/dd' format. But from the screenshots, it seems that you display date hierarchy instead of date value so the TOTALMDT is not working. In your scenario, you need to display date value in the table, then change aggregate function for the [Matter no count] as SUM, then create the measure like below:
MTD_Arrangements=TOTALMTD(SUM('Fixed arrangement'[Matter no count]),'Datekey'[Date])
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
Hi Smoupre,
I have moved on to a new data set but the formulas remain the same in principle. ONe fgives me the sum per day and the other returns the mtd total in each day as opposed to the cumulative total in each day. I need it to return the below data set.
I hope that this is clear.
Cheers,,
Bruce
Community SupportHi bjones,
As you mentioned in original post, the date is 'yyyy/MM/dd' format. But from the screenshots, it seems that you display date hierarchy instead of date value so the TOTALMDT is not working. In your scenario, you need to display date value in the table, then change aggregate function for the [Matter no count] as SUM, then create the measure like below:
MTD_Arrangements=TOTALMTD(SUM('Fixed arrangement'[Matter no count]),'Datekey'[Date])
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu