Create a new table with current date

[Raulx_7]

Hi, I'm doing a dashboard, however this dashboard has a date filter (like 7 dates), and I want to display only the latest date selected.  That's why I decided to create a new table which contains the value of only the selected date, in order to use it as a filter for many graphs, is this possible? 

I have tried using Max(Dates[date]), and SELECTEDVALUE, but nothing works .

[amitchandak]

@Raulx_7 , Max from date table dependent on the calendar

Try like

New Table =

Var _max = maxx(Table, Table[Date])

return

calculatetable(Table, filter(Table, Table[Date] = _max ))

You can even try measure like

New measure=

Var _max = maxx(Table, Table[Date])

return

calculate([Measure], filter(Table, Table[Date] = _max ))

[Raulx_7]

Thanks, I've tried this one : 

New Table =

Var _max = maxx(Table, Table[Date])

return

calculatetable(Table, filter(Table, Table[Date] = _max ))

But it says that the syntax for a table is not correct. 

[v-jayw-msft]

Hi @Raulx_7 ,

Try this formula.

new table = DISTINCT(SELECTCOLUMNS('Table',"latest date",MAX('Table'[date])))

Result would be shown as below.

 

Best Regards,

Jay