Forum Discussion

kjaworski's avatar
kjaworski
Regular Visitor
9 years ago
Solved

DAX - multiple conditions

Hello    I'm trying to do simple filtering using multiple conditions. At least I thought it would be easy.   Here are the columns:   Amount AmountLeft EndDate status 100 50 2016.12.3...
Need Help
  • kjaworski's avatar
    kjaworski
    9 years ago

    I guess it works fine now in this version

     

    Status = IF(Query1[BonusAmount] = 0 || Query1[BonusLeft] < 0 || Query1[EndDate] < TODAY() && Query1[EndDate] <> BLANK(); "CLOSED"; "active")

     

    Am I right?

Baskar's avatar
Baskar
Resident Rockstar
9 years ago

It working fine for me.

 

 

 

 

 

Check the date coolumn which datatype it is ?

create Calculated column .

 

Let me know what error if u getting.