Hi there:
I am new to PBI and know that there must be a way that I can reduce the repetitiveness of my code when creating a custom conditional column. Currently I am re-writing the same code structure to indicate if any single individual category equals 1 and the other values are 0, then the result is "1 Category", and repeating these combinations all the way up to "4+ Categories" and the result should be mutually exclusive. Example below. I would LOVE a simpler way to do this if possible and I have been overthinking this to my detriment, thanks!
= if
[Category1] =1 and (
[Category2] =0 and
[Category3]=0 and
[Category4]=0 and
[Category5]=0 and
[Category6]=0 ) then "1 Category"
else if
[Category2] =1 and (
[Category3]=0 and
[Category4]=0 and
[Category5]=0 and
[Category6]=0 and
[Category1] =0) then "1 Category"
.
.
.
else if
[Category1] =1 and [Category2] =1 and (
[Category3]=0 and
[Category4]=0 and
[Category5]=0 and
[Category6]=0 ) then "2 Categories"
... and so on until all combination of catoegies have been accounted for.
