Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Subtraction two vales

Hi   I would like to show a measure based on end of the month’s value from one table minus today's value in another   Thanks
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    Here is my sample data (Today is 2024.7.24):

    Use this DAX to create a measure:

    Difference = 
VAR _PreviousMonthEndDay = EOMONTH(TODAY(), -1)
VAR _PreviousMonthValue = 
CALCULATE(
    SUM('Table (2)'[Value]),
    'Table (2)'[Date] = _PreviousMonthEndDay
)
VAR _TodayValue = 
CALCULATE(
    SUM('Table'[Value]),
    'Table'[Date] = TODAY()
)
RETURN
_PreviousMonthValue - _TodayValue

    And the final output is as below:


    Best Regards,
    Dino Tao
    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 Anonymous ,

Here is my sample data (Today is 2024.7.24):

Use this DAX to create a measure:

Difference = 
VAR _PreviousMonthEndDay = EOMONTH(TODAY(), -1)
VAR _PreviousMonthValue = 
CALCULATE(
    SUM('Table (2)'[Value]),
    'Table (2)'[Date] = _PreviousMonthEndDay
)
VAR _TodayValue = 
CALCULATE(
    SUM('Table'[Value]),
    'Table'[Date] = TODAY()
)
RETURN
_PreviousMonthValue - _TodayValue

And the final output is as below:


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