Variations with specific dates

[nesrine]

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 week chosen .

THANK YOU VERY MUCH FOR YOUR HELP

[v-piga-msft]

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

[nesrine]

Hello,

yes, in fact it's not clear. 

so my output is the coloun evolution, i want to show it in my dashboard every time i choose a date 

thank you,

best regards,

[v-piga-msft · Accepted solution]

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