Forum Discussion
SUM MTD if multiple months are selected in filter
Hi User1021 to proper use MTD values, it is the best when you have Date / Calendar table
In your case, measure MTD could be:
MTD test = TOTALMTD(SUM ( 'Sales invoice line fact'[Invoice TON_] ),'Date'[Date])
'Date'[Date] should be your Calendar / Date key column connected with your table
Create Calendar Table Microsoft Learn
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-calculated-tables
TOTALMTD Fuction
https://learn.microsoft.com/en-us/dax/totalmtd-function-dax?WT.mc_id=DP-MVP-4025372
Did I answer your question? Kudos appreciated / accept solution!
TOTALMTD function will not work as I have mentioned that my date table is fiscal calendar 445.
- some_bih3 years ago
Community Champion
Hi User1021 I only saw MTD🙂
check link below, could be usefull for your case
https://www.linkedin.com/pulse/creating-4-4-5-fiscal-calendar-power-bi-dax-norman-maxwell/