Forum Discussion

sahubibhuti45's avatar
sahubibhuti45
Helper I
2 years ago

Creating a table based on selection date

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.
 
Need Help

2 Replies

  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    Super User
    2 years ago

    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's avatar
      sahubibhuti45
      Helper I
      2 years ago

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