'Is there a better way of writing this DAX formula?
Is there a better way of writing the below DAX formula? I tried using SWITCH, but it didn't like the numerical and text combination. This data comes from an MS forms survey, and I can't change the survey data source. Also, as it is a live survey I don't want to manually download and transform the data, so I thought using a calculated column would be the best option.
Today: (c) = IF([Today:]="SHELL VALUE", 1, (IF([Today:]="B", 2, IF([Today:]="C", 3,IF([Today:]="D", 4,IF([Today:]="E", 5,IF([Today:]="F", 6,IF([Today:]="CUST. VALUE", 7,0))))))))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|