Get the value or category associated on the selected date parameter/slicer

[cruzp]

I want to have a date selected value based on the existing dates from the SNAPSHOT_DATE_BK and use that as a parameter/a date to interact with the calculations that i will explain in the following  part.

I have a data like that:

PROJECT_BK	PROJECT_NAME	REVENUE_CATEGORY_BK	SNAPSHOT_DATE_BK
PROJ-0021	POC - Cloud	RC_PS_TM	07/12/2022
PROJ-0021	POC - Cloud	RC_PS_TM	08/12/2022
PROJ-0021	POC - Cloud	RC_PS_TM	13/11/2022
PROJ-0021	POC - Cloud	RC_DX_EF	14/10/2022
PROJ-0021	POC - Cloud	RC_DX_EF	15/10/2022
PROJ-0021	POC - Cloud	RC_DX_EF	20/09/2022
PROJ-0021	POC - Cloud	RC_DX_EF	21/09/2022
PROJ-1111	3DL - Tokenized	DB_TD_ER	23/12/2022
PROJ-1111	3DL - Tokenized	DB_TD_ER	01/12/2022

Help me create a table that shows the value of the REVENUE_CATEGORY_BK based on the selected date parameter that contains values available only in the SNAPSHOT_DATE_BK, and if the date parameter does not have a value for REVENUE_CATEGORY_BK, it will show Null.

Expected Output Sample 1 -  when a Date Parameter/Slicer is selected 23/12/2022, the value for the calculated CURRENT_REVENUE_CATEGORY_BK will show 'Null' since PROJ-0021 does not have a REVENUE_CATEGORY on 23/12/2022.

Expected Output Sample 2 - when a Date Parameter/Slicer is selected 14/10/2022, the value for the CURRENT_REVENUE_CATEGORY_BK will show 'RC_DX_EF' since that is the associated REVENUE_CATEGORY_BK for that specific Date.

Expected Output Sample 3 - when a Date Parameter/Slicer is selected 07/12/2022, the value for the CURRENT_REVENUE_CATEGORY_BK will show 'RC_PS_TM' since that is the associated REVENUE_CATEGORY_BK for that specific Date.

[lbendlin]

Sounds like all you need is a slicer or a page level filter for SNAPSHOT_DATE_BK ?