Forum Discussion

Asmaa-elsheikh's avatar
Asmaa-elsheikh
Icon for Helper I rankHelper I
2 years ago
Solved

MTD Calculation

Hi All, I need your support; I am trying to calculate MTD,but it gives me inacurrate numbers, here the method I used: =Calculate(SUM(COUNT),MONTH(Updated_Date)=MONTH(TODAY())  I have used th...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Asmaa-elsheikh ,

    I create a table as you mentioned.

    When I write your DAX code, it gives me an error. I think you can change COUNT.

    Then I change the DAX code, it gives me the result you want.

     

    Measure =
CALCULATE (
    SUM ( 'Table'[Count] ),
    MONTH ( 'Table'[Updated_Date] ) = MONTH ( TODAY () )
)

     

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Asmaa-elsheikh's avatar
Asmaa-elsheikh
Icon for Helper I rankHelper I
2 years ago

Yes, I need the mTD to show only values for March & to be dynamic to show the MTD per each coming month without the need to filter values manually each month, is there any way to do ?

audreygerred's avatar
audreygerred
Icon for Super User rankSuper User
2 years ago

Hi, yes, absolutely. Assuming you have a date dim table and have it marked as the date table, you would create your MTD measure with the quick measure and use the date from the date table in the measure. Then, put your date field from the date table in filters on the page (or entire report of you want) and set it to relative date, in this month. This will allow it to dynamically be in the correct month.