Forum Discussion

Asmaa-elsheikh's avatar
Asmaa-elsheikh
Helper 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.

Anonymous's avatar
Anonymous
Not applicable
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.