Forum Discussion
Solved
Variance and variance %
Please advise on how to create a variance and a variance % as per below: I have created two calculations which compute a measure for a period of time. This year to date and last year to date: 1....
Hi,
See my attached pbix file.
Hope this can help.
Best Regards,
Giotto
Variance = [This YTD] - [Last YTD]
Variance % = DIVIDE ( ([This YTD] - [Last YTD]), [Last YTD], 0)
- SV
Thank you so much for the reply .. on the variance amount (this year - last year) .. the value doesn't reflect correctly. The variance amount is the same as the actual amount.. it shows as follows:
Country 2019 var 2020 var
Spain 100 100 150 150
it shoud show
Country 2019 var 2020 var
Spain 100 0 150 50