topic Re: Percentage Change Division By Zero in DAX Commands and Tips

Percentage Change Division By Zero

Anonymous — Tue, 29 Oct 2019 18:55:55 GMT

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?

Re: Percentage Change Division By Zero

Nathaniel_C — Tue, 29 Oct 2019 20:55:49 GMT

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

Re: Percentage Change Division By Zero

Anonymous — Tue, 29 Oct 2019 21:09:25 GMT

Nathaniel_C

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

Re: Percentage Change Division By Zero

Nathaniel_C — Tue, 29 Oct 2019 21:29:38 GMT

You are welcome! Is NPV Net Present Value?