SWITCH Function in DAX for Excel and Power BI

The SWITCH function in DAX can be used to replace the nested IF statement.  It is both easier to read and easier to write. SWITCH was introduced in PowerBI in Nov 2016 and it is also available in updated versions of Excel 2016 By the end of this article and examples, you will Understand the […]

DAX Divide Function

DAX Divide Function – DAX for Power BI and Power Pivot

When you are working in Excel it is relatively easy to divide two numbers. You take the value from one cell, and divide it by the value or the in another cell.  For Example =B3/B2.  Divide is a basic mathematical operator. In Excel if you try to divide a value by zero you will get the error […]