Forum Discussion

rosscortb's avatar
rosscortb
Post Patron
5 years ago
Solved

value format error in if statement

Hello,

 

What do I need to do to fix this format/value error please?

Column = IF('Spans & Layers'[Direct Reports] > 10,"Red",IF('Spans & Layers'[Direct Reports] >=1 <= 2,"Red",IF('Spans & Layers'[Direct Reports] >= 6 <=10,"Green",IF('Spans & Layers'[Grade] = "S1"||"S2"||"S3"||"S4","Black","Orange"))))
 
 
Thanks
Ross
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi  rosscortb ,

    You can modify your dax like this:

    Column = 
IF('Spans & Layers'[Direct Reports] > 10,"Red",
IF('Spans & Layers'[Direct Reports] >=1 || 'Spans & Layers'[Direct Reports] <= 2,"Red",
IF('Spans & Layers'[Direct Reports] >= 6 || 'Spans & Layers'[Direct Reports]<= 10,"Green",
IF('Spans & Layers'[Grade] in {"S1","S2","S3","S4"},"Black","Orange"))))

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

6 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    5 years ago

    rosscortb little confused with your formula pattern. It's better if you could explain in a word or algorithm format. 

     

  • Tahreem24's avatar
    Tahreem24
    Super User
    5 years ago

    rosscortb I tried formulate it as per my understanding. Try this out and let me know if it's giving you correct result or not. 


    Column = IF('Spans & Layers'[Direct Reports] > 10,"Red",IF('Spans & Layers'[Direct Reports] >=1 && 'Spans & Layers'[Direct Reports] <= 2,"Red",IF('Spans & Layers'[Direct Reports] >= 6 && 'Spans & Layers'[Direct Reports] <=10,"Green",IF('Spans & Layers'[Grade] = in {"S1","S2","S3","S4"},"Black","Orange"))))

     

    • rosscortb's avatar
      rosscortb
      Post Patron
      5 years ago

      Tahreem24 it had errors with <=  and then in.

      So, changed to this but still has the value and format error as seen in my previous screenshot

      Column = IF('Spans & Layers'[Direct Reports] > 10,"Red",IF('Spans & Layers'[Direct Reports] >=1 <= 2,"Red",IF('Spans & Layers'[Direct Reports] >= 6 <= 10,"Green",IF('Spans & Layers'[Grade] in {"S1","S2","S3","S4"},"Black","Orange"))))
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi  rosscortb ,

    You can modify your dax like this:

    Column = 
IF('Spans & Layers'[Direct Reports] > 10,"Red",
IF('Spans & Layers'[Direct Reports] >=1 || 'Spans & Layers'[Direct Reports] <= 2,"Red",
IF('Spans & Layers'[Direct Reports] >= 6 || 'Spans & Layers'[Direct Reports]<= 10,"Green",
IF('Spans & Layers'[Grade] in {"S1","S2","S3","S4"},"Black","Orange"))))

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.