Syntax
Tutorial with example
Do you know the difference between zeros, nulls and empties?? Lets take a look at that so we can understand why we the power bi team introduced a new comparison operation, kindof..:
Download example files:
Download the pbix and excel file here.
Remarks
This formula computes the increase or decrease ratio in sales compared to the previous year. The example uses the IF function to check the value for the previous year’s sales in order to avoid a divide by zero error.
Let us know your thoughts...