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, but now trying to break the values down by week. And this value will change again by next day.
Example
By next day if I run this report, the End of week will be 2/9/2024, 2/2/2024, and etc.
Is there a way to do that? It can be either query editor or DAX.
Appreciate any input you can provide. Thank you in advance.
2 Replies
peifc75 Are you looking for this? Rolling Weeks - Microsoft Fabric Community
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%
