Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Create Filter for Model with 'Or' case

Hi, 

 

I have q model with no meaures calculated. 

I am needing to filter the date on this case

 

Filter whe cancellation.date is null OR cancellation.date > accounting date

 

How do i filter the entire model for this case?

Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous you can do it by adding a column either using power query or DAX and filter on that column

     

    Add following measure using DAX

    Filter Date = 
IF( Canellation[Date] == BLANK() || Canellation[Date] > Cancellation[AccountingDate], 1, 0 )

    Now you can use Filter Date column in your report/page/visual level filter where value = 0

     

     

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous you can do it by adding a column either using power query or DAX and filter on that column

     

    Add following measure using DAX

    Filter Date = 
IF( Canellation[Date] == BLANK() || Canellation[Date] > Cancellation[AccountingDate], 1, 0 )

    Now you can use Filter Date column in your report/page/visual level filter where value = 0