Creating a table based on selection date

[sahubibhuti45]

I have a rate list history table which is having day level data. I want to create anew table from the rate list table by using a dax which will give me the table based on a maximum slicer selection date.

I have used the below dax functions

for getting the maximum of slicer selection date i am using the below dax

maxdateslicer = MAXX(ALLSELECTED(CALENDERTABLE),CALENDERTABLE[Date].[Date])

To create a new toble of the max of the rate list date 

Ex_Rate_Today = CALCULATETABLE(Rate_List,FILTER(Rate_List,Rate_List[RTLIST_DATE]=MAX(Rate_List[RTLIST_DATE])))

To create table based on the slicer date

FilteredTable =

FILTER (

    'RATE LIST',

    'RATE LIST'[RTLIST_DATE].[Date]= [maxdateslicer]

)

Thebolded query is not working.

Can someone please help here for creating a table based on slicer maximum date.

[Sahir_Maharaj]

Hello @sahubibhuti45,

For the FilteredTable measure, can you please try the following:

FilteredTable = 
CALCULATETABLE(
    'RATE LIST',
    FILTER(
        ALL('RATE LIST'),
        'RATE LIST'[RTLIST_DATE] = [maxdateslicer]
    )
)

[sahubibhuti45]

Hi , This query is not giving any error but also not giving any data.