Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
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.           

     

Anonymous's avatar
Anonymous
Not applicable
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.