Forum Discussion

PBINewbie920's avatar
PBINewbie920
Helper I
4 years ago
Solved

Create column based on table

Hi Everyone,   I created a measure to calculate the % Variance between Actuals and Budget. Based on this, I would like to create a new column to give points based on how much variance, as show belo...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi PBINewbie920 ,

     

    What about trying the SWITCH() function? Please try this measure.

    Measure = 
SWITCH(
    TRUE(),
    [% Variance] <= 0.01 , 0 ,
    [% Variance] > 0.01 && [% Variance] <= 0.1 , 5 ,
    [% Variance] > 0.1 && [% Variance] <= 0.2 , 10 ,
    [% Variance] > 0.2 , 15
)

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi PBINewbie920 ,

 

What about trying the SWITCH() function? Please try this measure.

Measure = 
SWITCH(
    TRUE(),
    [% Variance] <= 0.01 , 0 ,
    [% Variance] > 0.01 && [% Variance] <= 0.1 , 5 ,
    [% Variance] > 0.1 && [% Variance] <= 0.2 , 10 ,
    [% Variance] > 0.2 , 15
)

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data