Power BI - Assign value to column depending on another columns value.

[Brad]

As the title suggests, i want to assign a value to a column depending on another columns value. For example, if the a field in the 'car' column had a value between 0-9 i want the corressponding field in the 'cargroup' column to be 1. If the value in 'car' was 10-19 i want the value in 'cargroup' to be 2 and so on... What formula would i use to do this?

[Sean]

Column =
SWITCH (
    TRUE (),
    'Table'[Car] >= 0  && 'Table'[Car] <= 9, 1,
    'Table'[Car] >= 10 && 'Table'[Car] <= 19, 2,
    3
)

[v-huizhn-msft · Accepted solution]

Hi @Brad,

The formula @Sean posted is correct. I have test it, it returns the right result.



If you have have resolved your issue, please mark corresponding reply as answer, which will help other people find the solution easily.

Best Regards,
Angelia