Calculated Column

[sdhn]

Hi all,

I need to create calculated column in power bi as below:

Column =(col1-col2)/col2

Will appreciate your help. 

[sdhn]

Thanks, great help

[VahidDM]

Hi @sdhn 

Can you share a sample of your data in a text format?

BTW, try this:

Column =([col1]-[col2])/[col2]

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[sdhn]

If both columns have "0" value output come as NaN

Column =([0]-[0])/[0]

output is "NaN"

in one row I have value for column 1 = 13

column 2 = 0

Column =([13]-[0])/[0]

Out put is  infinity 

[sdhn]

Sum values come in new  column come as "NaN" & in one row value of New Column is  "Infinity".  Rest rows are fine.   Any advise Thanks 

[VahidDM]

@sdhn 

Try this:

Column =IF([col2]=0,blank(),([col1]-[col2])/[col2])

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[sdhn]

Great , thi ssolve the issue.  One more request.

I am getting negative figures in few rows. 

as -0.3 %.  I want to display any "-" as '0'.   Can you help on this too? thanks 

[sdhn]

I meant Just display 0 if there is any negative "-"  number 

[VahidDM · Accepted solution]

Hi @sdhn 

try this:

Column =
IF (
    [col2] = 0,
    BLANK (),
    IF ( [col1] - [col2] < 0, 0, ( [col1] - [col2] ) / [col2] )
)

If my posts helps, please consider accepting them as solutions to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/