Forum Discussion

sahubibhuti45's avatar
sahubibhuti45
Icon for Helper I rankHelper 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 d...
Need Help
Sahir_Maharaj's avatar
Sahir_Maharaj
Icon for Super User rankSuper 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
    Icon for Helper I rankHelper I
    2 years ago

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