Hello everyone,
I have the following tabel:
<tbody>
</tbody>
Now I am Looking for a function for an calculated column (Power Pivot), which categorize the Area in the following groups
A1-A5 = AA
A15-A16 = AB
A20-30 = AC
A90-A100 = AD
How would you manage that?
A simple IF-Clause?
Best Regards
Joshua
I have the following tabel:
Dep | Area |
A | A1 |
A | A2 |
A | A3 |
A | A4 |
A | A5 |
A | A15 |
A | A16 |
A | A20 |
A | A21 |
<tbody>
</tbody>
Now I am Looking for a function for an calculated column (Power Pivot), which categorize the Area in the following groups
A1-A5 = AA
A15-A16 = AB
A20-30 = AC
A90-A100 = AD
How would you manage that?
A simple IF-Clause?
Best Regards
Joshua