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.

     

DataZoe's avatar
DataZoe
Microsoft Employee
5 years ago

Anonymous You can use this to have it mark the the latest date in a calculated column, then use that in a slicer:

 

Latest = if(financials[Date]=CALCULATE(max(financials[Date]),all(financials)),"Current","Past")
 

 

 
 
 
 
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks DataZoe ,  i want to clarify. First create a  measure and then use the IF condition? please explain.

    Thanks