Forum Discussion
Solved
MTD Measure to current date
Please i need some help. I am trying to create a MTD measure in my report. I am extremely new with DAX and power bi. I was thinking that i was doing it correctly, however, i have some stores th...
Sachet_716,
You would need to add Month field or Date field to your visual. For more details about how TOTALMTD function works, please review this article: https://msdn.microsoft.com/en-us/library/ee634560.aspx.
Regards,
Lydia
Hello Kieran,
Here is my table. I am expecting that the 2 stores which i highlighted will appear since i need MTD data, without doing any filters. However, whenever i choose 'November' in my slicer, it gives me the correct data.
I might be doing it wrong?
Thank you.
Cris
Sachet_716,
You would need to add Month field or Date field to your visual. For more details about how TOTALMTD function works, please review this article: https://msdn.microsoft.com/en-us/library/ee634560.aspx.
Regards,
Lydia
Thank you Lydia. :)