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.

MNedix's avatar
MNedix
Icon for Solution Sage rankSolution Sage
2 years ago

Hi,

Why not using the built-in functions?

=CALCULATE(SUM(COUNT),DATESMTD(Updated_Date))
Asmaa-elsheikh's avatar
Asmaa-elsheikh
Icon for Helper I rankHelper I
2 years ago

I have used it, but gives me blank values