Forum Discussion

BR-MSBI's avatar
BR-MSBI
Frequent Visitor
2 years ago
Solved

If, Or, Else not working

I am working with customer data and I am trying to segment them based on various demographic and lifestage information e.g. if someone is 18-21 years old or 35-39 years old and working full time or p...
AND
DAX for IF
else
OR
  • lbendlin's avatar
    lbendlin
    2 years ago

    use PowerQueryFormatter.com to bring your code into a readable format

    let
  a = 
    if List.Contains({"Under 18", "18-21", "22-29", "30-34", "35-39"}, [Q1_Age])
      and (
        {
          [#"Q6_Employment_Working full time (30 hours or more work per week)"]
            = 1 or [#"Q6_Employment_Working part time (under 30 hours work per week)"]
            = 1
        }
      )
      and ([Q2_Parent_None of these apply] = 1)
      and List.Contains(
        {"Single/Never married", "De facto/Living with partner but not married"}, 
        [Q3_Marital_Status]
      )
    then
      "SEGMENT A"
    else
      null
in
  a

     

    Then validate if that is the actual logic you wanted to implement

BR-MSBI's avatar
BR-MSBI
Frequent Visitor
2 years ago

Hi there, let me try to compare the two to see if there any spelling or case differences first. I am comfortable sharing the data in an open forum like this. 

Will circle back! 

BR-MSBI's avatar
BR-MSBI
Frequent Visitor
2 years ago

So the Syntax is certainly working, I know that because I have only written the syntax for one segment and the rows that are showing as errors are where it needs to display "segment A", which is great!! so when I look at the errors this is what I see "Expression.Error: We cannot convert a value of type List to type Logical.
Details:
Value=[List]
Type=[Type]

Doesn't this mean tha one of the lists can't be calculated becuase it is text? 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Please show your code.

    • BR-MSBI's avatar
      BR-MSBI
      Frequent Visitor
      2 years ago

      =if List.Contains({"Under 18","18-21","22-29","30-34","35-39"},[Q1_Age]) and ({[#"Q6_Employment_Working full time (30 hours or more work per week)"]=1 or [#"Q6_Employment_Working part time (under 30 hours work per week)"]=1}) and ([Q2_Parent_None of these apply]=1) and List.Contains({"Single/Never married", "De facto/Living with partner but not married"}, [Q3_Marital_Status]) then "SEGMENT A" else null

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        use PowerQueryFormatter.com to bring your code into a readable format

        let
  a = 
    if List.Contains({"Under 18", "18-21", "22-29", "30-34", "35-39"}, [Q1_Age])
      and (
        {
          [#"Q6_Employment_Working full time (30 hours or more work per week)"]
            = 1 or [#"Q6_Employment_Working part time (under 30 hours work per week)"]
            = 1
        }
      )
      and ([Q2_Parent_None of these apply] = 1)
      and List.Contains(
        {"Single/Never married", "De facto/Living with partner but not married"}, 
        [Q3_Marital_Status]
      )
    then
      "SEGMENT A"
    else
      null
in
  a

         

        Then validate if that is the actual logic you wanted to implement