Tag Archives: Using SWITCH to Replace CHOOSE in Power Query Excel

This blog article shows you how to use SWITCH in Power Query Excel. In Excel, you have Choose function. An example is like the following. = Choose (Weekday(A2), “Sunday,”, “Monday,” “Tuesday,” “Wednesday,” “Thursday,” “Friday,” “Saturday”). Unfortunately, there is no Choose … Continue reading →