Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a Table where i doing Fill down Null values for Reported_Cummulative and Closed_Cummulative for All the Future Weeks.
But i would like to filter data untill Current Week Rather than doing it manually.
The Table looks like below. Need help in defining filter to show data untill Current Week.
PROJECT_KEY | YEAR | WEEK_NUM | REPORTED_CUMMULATIVE | CLOSED_CUMMULATIVE |
ABC | 2022 | 1 | 0 | 0 |
ABC | 2022 | 2 | 0 | 0 |
ABC | 2022 | 3 | 0 | 0 |
ABC | 2022 | 4 | 0 | 0 |
ABC | 2022 | 5 | 0 | 0 |
ABC | 2022 | 6 | 0 | 0 |
ABC | 2022 | 7 | 0 | 0 |
ABC | 2022 | 8 | 0 | 0 |
ABC | 2022 | 9 | 0 | 0 |
ABC | 2022 | 10 | 0 | 0 |
ABC | 2022 | 11 | 0 | 0 |
ABC | 2022 | 12 | 0 | 0 |
ABC | 2022 | 13 | 0 | 0 |
ABC | 2022 | 14 | 0 | 0 |
ABC | 2022 | 15 | 0 | 0 |
ABC | 2022 | 16 | 0 | 0 |
ABC | 2022 | 17 | 0 | 0 |
ABC | 2022 | 18 | 0 | 0 |
ABC | 2022 | 19 | 0 | 0 |
ABC | 2022 | 20 | 0 | 0 |
ABC | 2022 | 21 | 0 | 0 |
ABC | 2022 | 22 | 0 | 0 |
ABC | 2022 | 23 | 0 | 0 |
ABC | 2022 | 24 | 0 | 0 |
ABC | 2022 | 25 | 0 | 0 |
ABC | 2022 | 26 | 0 | 0 |
ABC | 2022 | 27 | 0 | 0 |
ABC | 2022 | 28 | 0 | 0 |
ABC | 2022 | 29 | 0 | 0 |
ABC | 2022 | 30 | 0 | 0 |
ABC | 2022 | 31 | 0 | 0 |
ABC | 2022 | 32 | 0 | 0 |
ABC | 2022 | 33 | 0 | 0 |
ABC | 2022 | 34 | 0 | 0 |
ABC | 2022 | 35 | 0 | 0 |
ABC | 2022 | 36 | 0 | 0 |
ABC | 2022 | 37 | 0 | 0 |
ABC | 2022 | 38 | 0 | 0 |
ABC | 2022 | 39 | 0 | 0 |
ABC | 2022 | 40 | 0 | 0 |
ABC | 2022 | 41 | 0 | 0 |
ABC | 2022 | 42 | 0 | 0 |
ABC | 2022 | 43 | 0 | 0 |
ABC | 2022 | 44 | 0 | 0 |
ABC | 2022 | 45 | 1 | 0 |
ABC | 2022 | 46 | 4 | 0 |
ABC | 2022 | 47 | 9 | 0 |
ABC | 2022 | 48 | 20 | 0 |
ABC | 2022 | 49 | 34 | 0 |
ABC | 2022 | 50 | 38 | 1 |
ABC | 2022 | 51 | 46 | 1 |
ABC | 2022 | 52 | 51 | 2 |
ABC | 2022 | 53 | 52 | 2 |
ABC | 2023 | 1 | 52 | 2 |
ABC | 2023 | 2 | 54 | 3 |
ABC | 2023 | 3 | 58 | 7 |
ABC | 2023 | 4 | 63 | 8 |
ABC | 2023 | 5 | 63 | 8 |
ABC | 2023 | 6 | 65 | 8 |
ABC | 2023 | 7 | 69 | 14 |
ABC | 2023 | 8 | 71 | 16 |
ABC | 2023 | 9 | 72 | 18 |
ABC | 2023 | 10 | 76 | 22 |
ABC | 2023 | 11 | 77 | 23 |
ABC | 2023 | 12 | 82 | 26 |
ABC | 2023 | 13 | 83 | 28 |
ABC | 2023 | 14 | 87 | 29 |
ABC | 2023 | 15 | 89 | 32 |
ABC | 2023 | 16 | 96 | 33 |
ABC | 2023 | 17 | 103 | 38 |
ABC | 2023 | 18 | 103 | 40 |
ABC | 2023 | 19 | 109 | 45 |
ABC | 2023 | 20 | 112 | 49 |
ABC | 2023 | 21 | 116 | 51 |
ABC | 2023 | 22 | 119 | 56 |
ABC | 2023 | 23 | 120 | 57 |
ABC | 2023 | 24 | 121 | 63 |
ABC | 2023 | 25 | 125 | 68 |
ABC | 2023 | 26 | 126 | 69 |
ABC | 2023 | 27 | 126 | 74 |
ABC | 2023 | 28 | 126 | 76 |
ABC | 2023 | 29 | 128 | 78 |
ABC | 2023 | 30 | 128 | 83 |
ABC | 2023 | 31 | 128 | 84 |
ABC | 2023 | 32 | 129 | 85 |
ABC | 2023 | 33 | 132 | 88 |
ABC | 2023 | 34 | 133 | 89 |
ABC | 2023 | 35 | 133 | 91 |
ABC | 2023 | 36 | 133 | 93 |
ABC | 2023 | 37 | 134 | 95 |
ABC | 2023 | 38 | 134 | 96 |
ABC | 2023 | 39 | 140 | 96 |
ABC | 2023 | 40 | 146 | 100 |
ABC | 2023 | 41 | 146 | 103 |
ABC | 2023 | 42 | 147 | 105 |
ABC | 2023 | 43 | 147 | 106 |
ABC | 2023 | 44 | 148 | 109 |
ABC | 2023 | 45 | 148 | 109 |
ABC | 2023 | 46 | 149 | 110 |
ABC | 2023 | 47 | 152 | 113 |
ABC | 2023 | 48 | 153 | 117 |
ABC | 2023 | 49 | 155 | 122 |
ABC | 2023 | 50 | 158 | 123 |
ABC | 2023 | 51 | 160 | 124 |
ABC | 2023 | 52 | 161 | 126 |
ABC | 2023 | 53 | 161 | 126 |
ABC | 2024 | 1 | 161 | 127 |
ABC | 2024 | 2 | 161 | 127 |
ABC | 2024 | 3 | 161 | 128 |
ABC | 2024 | 4 | 163 | 128 |
ABC | 2024 | 5 | 164 | 129 |
ABC | 2024 | 6 | 164 | 129 |
ABC | 2024 | 7 | 164 | 129 |
ABC | 2024 | 8 | 164 | 129 |
ABC | 2024 | 9 | 164 | 129 |
ABC | 2024 | 10 | 164 | 129 |
ABC | 2024 | 11 | 164 | 129 |
ABC | 2024 | 12 | 164 | 129 |
ABC | 2024 | 13 | 164 | 129 |
ABC | 2024 | 14 | 164 | 129 |
ABC | 2024 | 15 | 164 | 129 |
ABC | 2024 | 16 | 164 | 129 |
ABC | 2024 | 17 | 164 | 129 |
ABC | 2024 | 18 | 164 | 129 |
ABC | 2024 | 19 | 164 | 129 |
ABC | 2024 | 20 | 164 | 129 |
ABC | 2024 | 21 | 164 | 129 |
ABC | 2024 | 22 | 164 | 129 |
ABC | 2024 | 23 | 164 | 129 |
ABC | 2024 | 24 | 164 | 129 |
ABC | 2024 | 25 | 164 | 129 |
ABC | 2024 | 26 | 164 | 129 |
ABC | 2024 | 27 | 164 | 129 |
ABC | 2024 | 28 | 164 | 129 |
ABC | 2024 | 29 | 164 | 129 |
ABC | 2024 | 30 | 164 | 129 |
ABC | 2024 | 31 | 164 | 129 |
ABC | 2024 | 32 | 164 | 129 |
ABC | 2024 | 33 | 164 | 129 |
ABC | 2024 | 34 | 164 | 129 |
ABC | 2024 | 35 | 164 | 129 |
ABC | 2024 | 36 | 164 | 129 |
ABC | 2024 | 37 | 164 | 129 |
ABC | 2024 | 38 | 164 | 129 |
ABC | 2024 | 39 | 164 | 129 |
ABC | 2024 | 40 | 164 | 129 |
ABC | 2024 | 41 | 164 | 129 |
ABC | 2024 | 42 | 164 | 129 |
ABC | 2024 | 43 | 164 | 129 |
ABC | 2024 | 44 | 164 | 129 |
ABC | 2024 | 45 | 164 | 129 |
ABC | 2024 | 46 | 164 | 129 |
ABC | 2024 | 47 | 164 | 129 |
ABC | 2024 | 48 | 164 | 129 |
ABC | 2024 | 49 | 164 | 129 |
ABC | 2024 | 50 | 164 | 129 |
Solved! Go to Solution.
Hi @JeevanMallya
I have created one calculated column in Power Query to dynamic filter
Please update the code as per your requirement
= if [WEEK_NUM] > Date.WeekOfYear(DateTime.LocalNow()) then "Greater Than Current Week" else "Less Than Current Week"
If your requirement is solved, please make sure to MARK AS SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.
Thanks
Pijush
Linkedin
Proud to be a Super User! | |
Thank you very much
You are welcome
Proud to be a Super User! | |
Hi @JeevanMallya
I have created one calculated column in Power Query to dynamic filter
Please update the code as per your requirement
= if [WEEK_NUM] > Date.WeekOfYear(DateTime.LocalNow()) then "Greater Than Current Week" else "Less Than Current Week"
If your requirement is solved, please make sure to MARK AS SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.
Thanks
Pijush
Linkedin
Proud to be a Super User! | |
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |