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?

kjaworski's avatar
kjaworski
Regular Visitor
9 years ago

Hello

 

Here is result in my powerbi

 

 

The "EndDate" column is Date type.

Baskar's avatar
Baskar
Resident Rockstar
9 years ago

U have Blank in End_Date column that is the problem.

 

If it is blank , then what u have to do ? u have to add that condition too.

  • kjaworski's avatar
    kjaworski
    Regular Visitor
    9 years ago

    Ups.

     

    If the EndDate is blank, it should be seen as EndDate > TODAY

    • kjaworski's avatar
      kjaworski
      Regular Visitor
      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

        Status =if ( Isblank(Query1[EndDate]) , "Active", IF(Query1[BonusAmount] = 0 || Query1[BonusLeft] < 0 || Query1[EndDate] < TODAY(), "CLOSED", "Active"))

         

         

        Try this this will help u