Month-to-date

[chloe914]

Hello all, I don't know why MTD cannot be calculated correctly using below formula, while the one using quick measure is work.

Is there is anything wrong on the formula?

Here is the file:

https://drive.google.com/file/d/1880pWiT-tyujOM9Gl9l1ioD68OM7E870/view?usp=share_link

Thank you!

MTD Sales = CALCULATE(SUM(Orders[Sales]),DATESMTD(Orders[Order Date]))

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[chloe914]

Great thanks!! 🙌

I followed your file and applied the changes to the other file and it works!

May I know why to add these?

- Add Calendar table, add relationship

- Add a new measure which is sum(orginal sales field)

[Ashish_Mathur]

hi,

The presence of a Calendar table allows one to use the Date/Time Intelligence functions.  One should always write explicit measures rather than dragging bare numeric fields to visuals.  This allows one to use those measures as inputs when writing other measures.