Forum Discussion
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 week chosen .
THANK YOU VERY MUCH FOR YOUR HELP
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
3 Replies
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
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,
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
