Forum Discussion
Helper IICompare a week data to prior week's data - Week data may be less than 7 days, so need to compare les
Hello All,
I am trying to compare Compare a week data to prior week's data - Week data may be less than 7 days, so need to compare the same number of days.
Data has 4 days in week 23.
Need to compare to the first 4 days in week 22
Getting the following error on my Max Week Day
Many thanks for your suggestions.
Open to other ways to do it.
Thanks,
Pav
I typically add columns to the date dimension YearsFromToday, MonthsFromToday, DaysFromToday, etc.
Negative is in the past, 0 is the current, positive is the future.
I have access to the DB views, but you can do this in Transform as well. See example, you could also have a "WeeksFromToday"
Then your DAX becomes stupid simple, to use your example:
Sale Count Week 1 = Calculate(Sale_count, DaysFromToday > -7 && DaysFromToday <= 0)
Sale Count Week 2 = Calculate(Sale_count, DaysFromToday > -14 && DaysFromToday <= -7)
....
Or better yet, leave sale count as it is and just apply a filter to the KPI or visual (unless you want to combine different weeks on different lines or etc on the same viz) Then you don't need a new measure for every week.
example:
If I answered your question, please mark my post as solution, Appreciate your Kudos
2 Replies
Data-estDogResolver II
I typically add columns to the date dimension YearsFromToday, MonthsFromToday, DaysFromToday, etc.
Negative is in the past, 0 is the current, positive is the future.
I have access to the DB views, but you can do this in Transform as well. See example, you could also have a "WeeksFromToday"
Then your DAX becomes stupid simple, to use your example:
Sale Count Week 1 = Calculate(Sale_count, DaysFromToday > -7 && DaysFromToday <= 0)
Sale Count Week 2 = Calculate(Sale_count, DaysFromToday > -14 && DaysFromToday <= -7)
....
Or better yet, leave sale count as it is and just apply a filter to the KPI or visual (unless you want to combine different weeks on different lines or etc on the same viz) Then you don't need a new measure for every week.
example:
If I answered your question, please mark my post as solution, Appreciate your Kudos
PavBidaniThanks