filter table by date and / or measure

[boyddt_mn]

I have a feeling that I'm missing something very simple but I am struggling with this.

I have the following tables and I need to filter for rows in the data that are the current 'ProdWeekYear'. The calendar file has the date and corresponding 'ProdWeekYear' and I've created a measure

ProdWeek = LOOKUPVALUE(JabilCalendar[ProdWeekYear], JabilCalendar[Date],"7/29/2021")

I was hoping to use this to filter the page but alas, cannot use measure to filter the page.

Here are the tables

Date	ProdWeekYear
7/12/2021	2021-28
7/13/2021	2021-28
7/14/2021	2021-28
7/15/2021	2021-28
7/16/2021	2021-28
7/17/2021	2021-28
7/18/2021	2021-28
7/19/2021	2021-29
7/20/2021	2021-29
7/21/2021	2021-29
7/22/2021	2021-29
7/23/2021	2021-29
7/24/2021	2021-29
7/25/2021	2021-29
7/26/2021	2021-30
7/27/2021	2021-30
7/28/2021	2021-30
7/29/2021	2021-30
7/30/2021	2021-30
7/31/2021	2021-30
8/1/2021	2021-30

Data

ProdWeekYear	MRP	MRP desc	Department	Weekly cMPS target	Daily cMPS target	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday	Weekly actual shipment	Remaining volume
2021-28	821	Description 1	Department 1	14.7	2.94	0	0	0	0	0	0	0	0	14.7
2021-28	822	Description 2	Department 2	0	0	0	0	0	0	0	0	0	0	0
2021-28	823	Description 3	Department 3	290.5	58.1	0	58	54	277	0	0	0	389	0
2021-28	824	Description 4	Department 4	41.7	8.34	0	0	0	0	0	0	0	0	41.7
2021-28	833	Description 5	Department 5	181.5	36.3	0	0	90	659	0	0	0	749	0
2021-29	101	Description 6	Department 1	41125.44	8225.09	10559	11191	5160	12222	433	4819	2807	47191	0
2021-29	102	Description 7	Department 2	12.6	2.52	0	12	0	0	12	0	0	24	0
2021-29	103	Description 8	Department 3	12663.75	2532.75	1653	2539	1682	2972	1183	1702	238	11969	694.75
2021-29	104	Description 9	Department 4	1714.25	342.85	2472	96	100	94	0	386	0	3148	0
2021-29	105	Description 10	Department 5	4016	803.2	2143	220	285	604	169	556	233	4210	0
2021-30	101	Description 11	Department 1	41125.44	8225.09	14176	11678	7645	10437	2718	0	0	46654	0
2021-30	102	Description 12	Department 2	12.6	2.52	0	0	0	0	0	0	0	0	12.6
2021-30	103	Description 13	Department 3	12663.75	2532.75	477	2043	705	2968	0	0	0	6193	6470.75
2021-30	104	Description 14	Department 4	1714.25	342.85	468	169	165	152	189	0	0	1143	571.25
2021-30	105	Description 15	Department 5	4016	803.2	328	83	1365	787	766	0	0	3329	687

Thank you in advance for any help offered.

[ryan_mayu · Accepted solution]

@boyddt_mn 

maybe try to create a column in date and use that column to filter data

Column = 
VAR _ProdWeekYear=maxx(FILTER('Table (2)','Table (2)'[Date]=today()),'Table (2)'[ProdWeekYear])
return if(_ProdWeekYear='Table'[ProdWeekYear],"Yes")

pls see the attachment below

[boyddt_mn]

That is exactly what I needed. Thank you for your quick response.

[ryan_mayu]

you are welcome