Display Dates in the past and for the next 60 days

[Samcooke]

Hi All,

I have a need to create a report that displays all items that are either alreay expired or that will expire in th enext 60 days. Below is a sample table. How do I set a filter to the next 60 days also keep the data in the past? And this data changes daily

WH_Id	Inv_Item_Part_Status_Name	Lot_Lot_Code	Lot_Exp_Date
1894	Kitted	209	1/31/2022 0:00
1894	Kitted	51824049	1/31/2022 0:00
1894	Kitted	116	11/30/2022 0:00
1894	Kitted	118	11/30/2022 0:00
1894	Kitted	119	11/30/2022 0:00
1894	Kitted	130	11/30/2022 0:00
1894	Kitted	178	11/30/2022 0:00
1894	Kitted	52377520	11/30/2022 0:00
1894	Kitted	52379487	11/30/2022 0:00
1894	Kitted	52393031	1/31/2023 0:00
1894	Kitted	52407290	2/28/2023 0:00
1894	Kitted	52407292	2/28/2023 0:00
1894	Kitted	52407293	2/28/2023 0:00
1894	Kitted	52407305	2/28/2023 0:00
1894	Kitted	52407934	2/28/2023 0:00
1894	Kitted	52408368	2/28/2023 0:00
1894	Kitted	52408900	2/28/2023 0:00
1894	Kitted	52409662	2/28/2023 0:00
1894	Kitted	52410159	2/28/2023 0:00
1894	Kitted	52411637	2/28/2023 0:00
1894	Kitted	52412606	2/28/2023 0:00

[Samcooke]

That was it. You rock. Thanks

[grantsamborn · Accepted solution]

If you are meaning display everything before 60 days from TODAY:

zMeasure = IF( MAX('Expirations'[Lot_Exp_Date]) < TODAY() + 60, "Expired", "Active")