Filter rows in query editor up to current Week

[JeevanMallya]

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

[JeevanMallya]

Thank you very much

[PijushRoy]

You are welcome

[PijushRoy · Accepted 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