Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

DAX Measures

I am trying to calculate and show sum of only the current month and not the YTD. I used this CurrentMonth = CALCULATE(SUM('YourTable'[YourColumn]), FILTER(ALL('Date'[Date]),'Date'[Date] >= STARTOFMON...
Need Help
  • hackcrr's avatar
    hackcrr
    2 years ago

    Hi, Your DAX metric looks correct for calculating the sum of the current month's columns. If this measure is not working as expected, ensure the following:
    Date Table Relationship: Ensure that the 'Date' table contains 'YourColumn' with the table.
    Date format: ensure that the t'Date' table
    DateRange in the data:
    Measurement Usage CurrentMonth: make sure you are using the ` measurement in the following context:

     

    Best Regards,

    hackcrr

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

hackcrr's avatar
hackcrr
Memorable Member
2 years ago

Hi, Your DAX metric looks correct for calculating the sum of the current month's columns. If this measure is not working as expected, ensure the following:
Date Table Relationship: Ensure that the 'Date' table contains 'YourColumn' with the table.
Date format: ensure that the t'Date' table
DateRange in the data:
Measurement Usage CurrentMonth: make sure you are using the ` measurement in the following context:

 

Best Regards,

hackcrr

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