Weekly Sales Data like in Excel Pivot

[MustafaP]

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

[swikritee_p · Accepted solution]

@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])))