Power BI: using SWITCH function
The SWITCH function compares a declared expression against all values. If the expression matches the value then it returns the result, if it doesn’t, it keeps moving down the list until the value is matched, or if nothing matched, then the formula returns the ELSE part.
#PowerBI #DAX #switch #IF