Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic Filter using measure

Hi All, My source is excel and the data is number of items (count) for each day. I have the counts on a score card. Since it is bringing sum of all the days i added a date filter and choose the late...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Anonymous ,

     

    1. Mark the largest date.

    2. Set the maximum date as the default value.

     

    Each time the date column is updated, the slicer will select the maximum date by default.

    The same is true for the solutions provided by amitchandak, DataZoe 

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Create a column like this in date table or table and filter that on MaxDate

 

Is max Date =
var _max = maxx(Table, Table[Date])
return
if('Date'[Date]=_max,"MaxDate",[Date]&"")

 

You can sort this on date column https://youtu.be/hfn05preQYA

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks Amitchandak,

I think my maxdate is not working, please see the attached screen shot and the calculation i used. My measure 

MAXDATE = MAXA(test[DATE])