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.

2 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    2 years ago

    Hi Anonymous 

     

    Do you want a MEASURE?  Measures are written in DAX, this is the Power Query forum and PQ uses the M language, not DAX.  PQ does not create measures.

     

    Please provide some sample data (in a file, not an image) and an example of the desired result.

     

    Regards

     

    Phil

  • 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.