Forum Discussion
Weekly Sales Data like in Excel Pivot
Hello,
I have a sales report in PowerBI, i would like to do same as in Excel Weekly Differences ( with previous week )
In Excel Pivot i made from groupping with 7 day like below, and differences from previous week.
I tryto get it in PowerBI, i can do but the order always wrong, i try to add serial order but now it's showing like below;
I tried to hide serial section but goes wrong order again.
How can i do this same like in Excel? Anybody can help?
Thank you
MustafaP , You should have a sort column for week.
Assuming the s.no can sort week correctly, you can use that as sort column.
Click on week column -> Column Tools -> Sort By Column -> and Choose S.No.
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
For Week on week, you can use offset function
Offset Previous Week = CALCULATE([Pax],OFFSET(-1, ALL('Table'[Week],'Table'[S. No]),ORDERBY('Table'[S. No])))
1 Reply
MustafaP , You should have a sort column for week.
Assuming the s.no can sort week correctly, you can use that as sort column.
Click on week column -> Column Tools -> Sort By Column -> and Choose S.No.
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
For Week on week, you can use offset function
Offset Previous Week = CALCULATE([Pax],OFFSET(-1, ALL('Table'[Week],'Table'[S. No]),ORDERBY('Table'[S. No])))