Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter on record that has an differend date

Hi all,   I was wondering if there is an way to achieve to following: - In my raw data I've got several customers, statusses and open_dates - In the reports I want to select one of the customers ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Create a measure as below then add it to visual filter.

    Measure = 
var _min = CALCULATE(MIN('Table'[open date]),FILTER(ALLEXCEPT('Table','Table'[customer]),'Table'[status]<>"closed"))
return
IF(SELECTEDVALUE('Table'[open date])>=_min,1,0)

     

    Best Regards,

    Jay

MFelix's avatar
MFelix
Super User
5 years ago

Hi Anonymous ,

 

Do you want this calculation to be dinamic based on the selection on of other fields on top of the customer or is it only the customer?

 

You could create an auxiliar table with the customer and the first date that is not closed and then use it has your filtering.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi, 

 

sorry about the delayed response.
It's only on the Customer that I need the first date that is different than 'Closed'.