Forum Discussion

k3rz0rg's avatar
k3rz0rg
Advocate III
8 years ago
Solved

Conditional column with ranged value.

Hi all,

 

I've been working with conditional column where I needed to put some values (please refer to the screen); is there any way I can set the value with range ie. 1-6 rather than 1,2,3,4,5,6?

 

Thanks,

K3

 

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi k3rz0rg,

     

    You can add a custom column referring to below M code:

    =if [Attribute] >= 1 and [Attribute] <= 6 then "Value1" else if [Attribute] > 6 and [Attribute] <= 10 then "Value2" else "Value3"

    Best regards,
    Yuliana Gu

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi k3rz0rg,

     

    You can add a custom column referring to below M code:

    =if [Attribute] >= 1 and [Attribute] <= 6 then "Value1" else if [Attribute] > 6 and [Attribute] <= 10 then "Value2" else "Value3"

    Best regards,
    Yuliana Gu

    • k3rz0rg's avatar
      k3rz0rg
      Advocate III
      8 years ago

      Thank you for the input, let me try that! I have a feeling that this might work in my case as well.