Forum Discussion
Getting variations by chaging data structure
Hi everyone, I have the following dataset: I would like to have a table like this one : For variation between 2018 and 2019 and also variation between Forecast and Sales in each ye...
i would just create a date tabe and then use the year from the hierarchy
see attached
vanessafvg thanks for helping!
Your solution gives the variation between Daily sales and forecast sales but doesn't give the variation between Daily sales in 2019 vs Daily Sales in 2018 or does it ?
Thank you
no it doesn't
you could do that like this
YOY variance =
var sales = CALCULATE(sum('Table'[Daily Sales]))
var previousyearsales = CALCULATE(sum('Table'[Daily Sales]), SAMEPERIODLASTYEAR('Table'[Date]))
return (DIVIDE(sales,previousyearsales))
you could do that like this
YOY variance =
var sales = CALCULATE(sum('Table'[Daily Sales]))
var previousyearsales = CALCULATE(sum('Table'[Daily Sales]), SAMEPERIODLASTYEAR('Table'[Date]))
return (DIVIDE(sales,previousyearsales))