Creating measure/visual table based on Slicer

[Anonymous]

Hi Everyone,

I'm hoping folks would be able to assist.  I've a table and I want to create a new dynamic table that updates based on my slicer.   The slicer is full of dates (1/1/2022,  2/1/2022, 3/1/2022).   I want the measure(s) to pull the record with latest date closest to my date slicer.  

Thanks so much everyone!

eg.

Table

ID	Date	Phase	Costs
1	1/1/2022	A	100
1	2/1/2022	B	200
1	3/1/2022	C	300
2	1/1/2022	A	100
2	2/1/2022	F	200
3	1/1/2022	A	100

If Slicer => Reporting Date = 1/1/2022

ID	Date	Phase	Costs
1	1/1/2022	A	100
2	1/1/2022	A	100
3	1/1/2022	A	100

If Slicer => Reporting Date = 2/1/2022

ID	Date	Phase	Costs
1	2/1/2022	B	200
2	2/1/2022	F	200
3	1/1/2022 (pulls from date closest to slicer)	A	100

If Slicer => Reporting Date = 3/1/2022

ID	Date	Phase	Costs
1	3/1/2022	C	300
2	2/1/2022 (pulls from date closest to slicer)	F	200
3	1/1/2022 (pulls from date closest to slicer)	A	100

[amitchandak]

@Anonymous , A calculated table can not use a slicer value. Only measure and visual table can use slicer values

[Anonymous]

Thanks Amit!  Do you know how I can create a measure for the visual table I want to generate?