SWITCH Function in Microsoft Excel | Currency Rate Conversion

1 year ago
3

🔴 Ditch the "IF () / IFS()" Function in MS Excel...

One of the popular Logical DAX functions in PowerBI is SWITCH() but few know that this function can be used in Excel as well. (Excel 2019)

Here is a short video of its application

Advantages of using Switch() over IF()..

📍Easy to read the code.
📍We can pass more conditions in the function with better readability.
📍Can be used to write more advanced logics.

1. Currency Rate Conversion
2. Comment on Dates

There are more uses of this function, "Explore the same & Have fun" 😊

Loading comments...