theexcelclub.com
SWITCH Function in DAX for Excel Power Pivot and Power BI - The Excel Club
The SWITCH function in DAX can be used to replace nested IF statement. It is easier to read and easier to write. Download the sample data to practice along