Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago
Solved

Value Calculation between relative dates

Hello community! I need to use in my dashboard a comparison of time recorded by users and compare it with the previous month. For this, I chose to use the meter visual. For informational purposes, ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Procito0o ,

     

    You can try below measure to get the previous month value.

    PreviousMonthValue = CALCULATE(SUM('Table'[Values]),FILTER(ALLSELECTED('Table'),[Users]=MAX('Table'[Users])),PREVIOUSMONTH('Table'[Dates]))

                                                                                                                                                             

    Best Regards,

    Stephen Tao

     

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

     

AmiraBedh's avatar
AmiraBedh
Icon for Super User rankSuper User
3 years ago

Firstly, ensure that the "Dates" column is recognized as date type. If not, you will need to convert it. You can do this using the Power Query Editor, or by simply changing the data type in the Fields pane.

Then create a measure to get the sum of values for the current month:

Current Month Total =
CALCULATE(
SUM('Table'[Values]),
'Table'[Dates] >= EOMONTH(TODAY(), -1) + 1,
'Table'[Dates] <= EOMONTH(TODAY(), 0)
)


This measure will calculate the sum of "Values" for all dates within the current month.

Then create another measure to get the sum of values for the previous month:

 

Previous Month Total =
CALCULATE(
SUM('Table'[Values]),
'Table'[Dates] >= EOMONTH(TODAY(), -2) + 1,
'Table'[Dates] <= EOMONTH(TODAY(), -1)
)


This measure will calculate the sum of "Values" for all dates within the previous month.


- Put the "Current Month Total" measure in the "Value" field.
- Put the "Previous Month Total" measure in the "Target Value" field.

This will provide a comparison of the total value for the current month versus the previous month.