Forum Discussion

Learner_SG's avatar
Learner_SG
Icon for Helper IV rankHelper IV
2 years ago

Power BI Direct Query Drop Down Table show the latest date.

Hi, I have a Power BI Report where I have a drop down table for my date. Now the date shown is the last selected date and each time I need to re-select to show the latest date. Is it possibl...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

Learner_SG , As of now, Power BI does not provide an outbox option for the latest date selection.

 

You need to have a column at Source, in this dax do not work and use that in visual

 

If( [Date] = Max([Date]) , "Latest Date", [Date] & "")

 

and use that in the slicer and save it on the latest date

 

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA

Learner_SG's avatar
Learner_SG
Icon for Helper IV rankHelper IV
2 years ago

amitchandak , thanks for the reply. But mine is a direct query model.

It's not possible to use it,right?