I want a new measure which i cannot work out on how to calculate the
Jan 2020 (441) - Jan 2021 (685) week on week comparison
and so on for all the months - the sample PBIX file show a measure for month over month difference. Kinldy ignore that i managed to do that.
See sample PBIX file.
Go to Solution.
@Route217 , Try like
total sales same week# previous month =
var _max = Max(DimDate[Date])
var _date = date(year(_max), month(_max)-12, Day(_max))
VAR currentyear = Year(_date)
VAR currentmonth = Month(_date)
VAR currentweeknumber = MAX(DimDate[weekinmonth])
CALCULATE([total sales], FILTER( ALL(DimDate), DimDate[Year] = currentyear && DimDate[MonthNo] = currentmonth && DimDate[weekinmonth] = currentweeknumber))
Also be careful on sort order, as you might not have prior data for 1 year. I got confused and done some reordeing
Proud to be a Super User!
View solution in original post
Thank you sir
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.