Forum Discussion
Rolling Calendar by week
I'm trying to figure out how to make a column that show end of week within calendar I created. This end of week is a rolling week. I need this to do a WoW calculation. I got the measurement correct, ...
I tried your method, unless I'm doing it wrong. It isn't exactly what I'm looking for.
This is the original tables created in Excel. I am trying to convert them over to Power BI. As you can see, the week end date changes daily each time I run it. I wonder if there is a possible way to do the same in Power BI. I don't want hard coded week over week (Sun to Sat).
Yesterday report...
| Orders Entered - 7 Day Totals | |||||||||
| East | Competitive | NP w/o Cancel | Other | NP | Total | Total w/o NPs | Comp Vols | PY %Var | |
| Current Week vs. Prior 4 | 98% | 170% | 80% | 104% | 111% | 83% | 119% | 92% | |
| 2024-02-11 | 780 | 3,365 | 2,708 | 18,238 | 6,853 | 3,488 | 119% | 88% | |
| 2024-02-04 | 880 | 2,700 | 3,625 | 21,344 | 7,205 | 4,505 | 116% | 99% | |
| 2024-01-28 | 766 | 1,624 | 3,613 | 13,707 | 6,003 | 4,379 | 99% | 100% | |
| 2024-01-21 | 692 | 1,729 | 3,040 | 16,938 | 5,461 | 3,732 | 90% | 87% | |
| 2024-01-14 | 846 | 1,877 | 3,287 | 17,906 | 6,010 | 4,133 | 95% | 94% | |
| 2024-01-07 | 785 | 1,995 | 3,423 | 18,910 | 6,203 | 4,208 | 100% | 96% | |
| 2023-12-31 | 646 | 2,460 | 3,032 | 22,556 | 6,138 | 3,678 | 94% | 94% | |
| 2023-12-24 | 640 | 1,483 | 3,060 | 13,646 | 5,183 | 3,700 | 101% | 108% | |
| 2023-12-17 | 654 | 1,770 | 3,330 | 16,234 | 5,754 | 3,984 | 92% | 99% | |
| 2023-12-10 | 745 | 1,815 | 3,438 | 17,079 | 5,998 | 4,183 | 108% | 99% |
Today report...
| Orders Entered - 7 Day Totals | |||||||||
| East | Competitive | NP w/o Cancel | Other | NP | Total | Total w/o NPs | Comp Vols | PY %Var | |
| Current Week vs. Prior 4 | 100% | 174% | 80% | 101% | 113% | 84% | 124% | 95% | |
| 2024-02-12 | 793 | 3,469 | 2,702 | 17,748 | 6,964 | 3,495 | 125% | 90% | |
| 2024-02-05 | 873 | 2,383 | 3,505 | 18,300 | 6,761 | 4,378 | 114% | 97% | |
| 2024-01-29 | 767 | 2,029 | 3,651 | 17,462 | 6,447 | 4,418 | 101% | 100% | |
| 2024-01-22 | 691 | 1,953 | 3,163 | 19,106 | 5,807 | 3,854 | 90% | 88% | |
| 2024-01-15 | 833 | 1,590 | 3,125 | 15,312 | 5,548 | 3,958 | 96% | 93% | |
| 2024-01-08 | 896 | 2,282 | 3,818 | 21,504 | 6,996 | 4,714 | 104% | 103% | |
| 2024-01-01 | 686 | 2,461 | 3,197 | 22,557 | 6,344 | 3,883 | 100% | 96% | |
| 2023-12-25 | 505 | 1,298 | 2,518 | 11,609 | 4,321 | 3,023 | 86% | 96% | |
| 2023-12-18 | 645 | 1,725 | 3,330 | 16,274 | 5,700 | 3,975 | 92% | 99% | |
| 2023-12-11 | 703 | 1,810 | 3,391 | 17,116 | 5,904 | 4,094 | 101% | 100% |