Forum Discussion

chloe914's avatar
chloe914
Frequent Visitor
3 years ago
Solved

Month-to-date

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]))

 

Need Help

3 Replies

    • chloe914's avatar
      chloe914
      Frequent Visitor
      3 years ago

      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's avatar
        Ashish_Mathur
        Super User
        3 years ago

        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.