In Direct query mode, how to get Max(Date) from date slicer date range

[SukanyaN]

Hi 

My requirement is to caluclate 12monthsrollingaverage from the selection daterange.

For that I need to store max value in measure so that can use this date in my further calculation.

I tried using SelectedValue() and AllSelected() but nothing worked.

Thanks

Sukanya

[v-qiaqi-msftv · Accepted solution]

Hi @SukanyaN,

IThanks for the reply from 3CloudThomas.

I have made a simple demo for your reference:

MaxDateSelected = 
MAXX(
    FILTER(
        'Table', 
       'Table'[DELDATE] <= MAX('Table'[DELDATE])
    ), 
    'Table'[DELDATE]
)

Regards,

Qi

[3CloudThomas]

Create a table in PowerQuery with the SQL SELECT MAX(DATECOLUMN) FROM TABLENAME. This will create a one column one row table with the maximum date from the table. Use it in your measures.