Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter data with a measure containing a date

Hello everyone,    I am trying to figure out how to filter data with a measure containing the latest month where data have been uploaded to the pwbi dataset. I want to be able to make by default th...
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous So it seems like you want something that I call a Complex Selector. https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534

     

    In your case it would be something like:

    Selector Measure = 
      VAR __CurrentDate = MAX('Table'[published (date)])
      VAR __Table = FILTER('Table',ALLEXCEPT('Table','Table'[id]))
      VAR __MaxDate = MAXX(__Table,[published (date)])
    RETURN
      IF(__CurrentDate = __MaxDate,1,0)

    You can then use this measure in the filter pane and filter for 1. __CurrentDate gets the current row's date and compares with the maximum date for that id. If they match, returns 1 otherwise 0. You could also do this as a column.