Forum Discussion

nesrine's avatar
nesrine
Frequent Visitor
7 years ago
Solved

Variations with specific dates

Hello !  i' looking to calculate the variation between two values by week. So if i have a coloun of date, i need to know the variation every week and be able to show it in my dashboard filtrerd by w...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi nesrine,

     

    If you want to calculate the Evolution, it seems that you want to calcuate the difference in one column based on date. You could refer to the fomula below.

     

    Column =
VAR tem =
    CALCULATE (
        MAX ( 'Table2'[NB app] ),
        FILTER ( 'Table2', EARLIER ( 'Table2'[Date] ) > 'Table2'[Date] )
    )
RETURN
    'Table2'[NB app]
        - IF ( tem = BLANK (), 'Table2'[NB app], tem )

     

     

    Best  Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi nesrine,

i' looking to calculate the variation between two values by week. So if i have a coloun of date, i need to know the variation every week and be able to show it in my dashboard filtrerd by week chosen .

 

Do you want to create a slicer with date and filter the week to show the variation?

 

Based on your imgae, it seems that the values in some rows are duplicate. Do you want to calculated the Evoloution column or that is the original data?

 

I 'm a little confused about your scenario, could you share your data sample which could reporduce your scenario and your desired output so that we could help further on it.

 

Best Regards,

Cherry