Forum Discussion

MustafaP's avatar
MustafaP
Frequent Visitor
2 years ago
Solved

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 differen...
General Comment
Need Help
  • swikritee_p's avatar
    swikritee_p
    2 years ago

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

swikritee_p's avatar
swikritee_p
Resolver II
2 years ago

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