Forum Discussion
TallGuy
1 year agoNew Member
Week over Week comparisons in two different graphs.
Hi everyone, Newbie here and I have a question about over time reporting. I have two tables and want to do a week over week comparison, but in two different graph sets for a total of 4 graphs. ...
Anonymous
1 year agoNot applicable
Hi TallGuy ,
Please try this measure:
NewMeasure = CALCULATE([YourMeasure],DATEADD('Date'[Date],-7,DAY))
It works by moving the time horizon of the measure forward by 7 days.
Also see this blog post on the measure [Sales PW]
Week-related calculations – DAX Patterns
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum