Percentage Change Division By Zero

[Anonymous]

Hello,

I'm using a matrix and trying to show percentage growth year over year. I've tried using an IF expression to correct, but it only fixes one of the 2 possible scenarios. I need the result to either by positive 100% if there is no value for the previous year, or -100% if there is no value for the current year.

Any suggestions? 

[Nathaniel_C · Accepted solution]

Hi @Anonymous ,

Wrap the measure or column with an Nested If measure = IF(ISBLANK(table[x]),100%,IF(ISBLANK(table[y]), -100%, [your measure])
This should give you the three outcomes that you are looking to see.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[Anonymous]

@Nathaniel_C 

Thank you so much! This worked like a charm. Appreciate the response.

[Nathaniel_C]

You are welcome! Is NPV Net Present Value?