Forum Discussion
DAX SWITCH with multiple combinations, with overlapping/shared values
Hi - I am trying to get the result in "Case" Column. Amount Rating Case 1000 1 1 1000 2 1 1000 3 1 1000 4 2 1000 5 2 1000 3 2 I have tried this: Switch Col...
OK, I think my logic is flawed here. Because logically, there is no way to tell the difference from the rating 3 which belongs to (1,2,3) and (4,5,3).
Thanks for having a look.
Back to the drawing board!