Forum Discussion
WEEK VARIATION
Hello, I need to have the variation % of my sales comparing it vs the last week like this: My power BI currently looks like this: And my table of time looks like this (S...
Hi Miguelcrz ,
Can you create a new column with below DAX:
Last Calendar Week Sales = CALCULATE( [Total Sales], 'Calendar'[Week Number] = WEEKNUM(TODAY(),1) -1 )
Use this to create another calculated column for % variation with below DAX:
Percent_Variation = (([Total Sales]-[Last Calendar Week Sales])/[Last Calendar Week Sales])*100
Hi! is not working. I only have the column week and the column sales. I have to calculate or do a new column to calculate the sales from last week but i dont know how. Then i need to calculate the variation between the sales of this week vs last week.
Thanks!
