User Profile
delavi
Frequent Visitor
Joined 8 years ago
User Widgets
Contributions
Re: Week Over Week Calculations
This is almost perfect for me. Made a couple small changes due to the way PBI counts days - otherwise this is awesome! WoW = VAR Week1 = CALCULATE ( SUM ( Table1[Sales] ), DATESINPERIOD ( Table1[Today], SELECTEDVALUE ( Table1[Today] ) - 0; -7, DAY ) ) VAR Week2 = CALCULATE ( SUM ( Table1[Sales] ), DATESINPERIOD ( Table1[Today], SELECTEDVALUE ( Table1[Today] ) - 7; -7, DAY ) ) RETURN DIVIDE ( Week1, Week2 ) - 1 @Vvelarde7KViews0likes0CommentsRe: Week Over Week Calculations
Trying to bump this along since I have been having the same issue. The closest solution I have gotten is to create the rolling 7 (WoW) in SQL as that is my data source. Still not what I wanted to do for the sake of using PBI fully. Also have submitted ticket to Power BI support. WoW should be an automatic feature for any BI tool.15KViews0likes0Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.