Avoiding -100% in calculations

[KBO]

Hi,

may be thats a stupid question but how can I avoid the -100% if I divide a value by a blank field.

Let me show you my problem :):

I only created a Measure with the last month and than I try to calculate the %.

Can anybody help?

As you can see I'm not a DAX person 😄

Best,

Kathrin

[jeffrey_wang]

if your formula is x/y - 1, change it to divide(x - y, y).

[KBO]

Hi @jeffrey_wang ,

my formular is like you meantion 

Percent Change = DIVIDE([SP Last Month]-[Total],[Total], 0)

Best,

Kathrin 

[jeffrey_wang · Accepted solution]

Change the formula to

Percent Change = IF([SP Last Month] <> 0, DIVIDE([SP Last Month]-[Total],[Total], 0))

[KBO]

Hi @jeffrey_wang ,

awesome 😉

It works great, thank you very much.

Thats why I love this community so much 🙂

Best,

Kathrin