If Column >< or = 0

[sdhn]

Hello All,

I have a spread sheet. I need to create calculate column for E, H & I columns in Power Bi. So my source spreadsheet will be without E, H & I columns. 

I like to calculate all columns through Power Bi.

For Column E formula in Spread sheet is as:  =IF(D2<=0,"N/A",(C2/D2))

For Column H formula in Spread sheet is as: =IF(D2>0,SUM(F2:G2),0)

For Column I formula in Spread sheet is as:  =IF(H2>0,(H2/D2),"N/A")

A	B	C	D	E	F	G	H	I	J
A1	32	29	61	47.5%	6.26	133.91	140.17	2.298	APRIL 2021
B1	72	0	72	0.0%	0.99	84.16	85.15	1.183	APRIL 2021

Help will be appreciated.   Thanks

[smpa01]

@sdhn  calculated column in dax

E = IF('Table'[D]<=0,0,DIVIDE('Table'[C],'Table'[D]))
H = IF('Table'[D]<=0,0,DIVIDE('Table'[C],'Table'[D]))
I = IF('Table'[H]>0,DIVIDE('Table'[H],'Table'[D]),0)

[sdhn]

Hi Smpa01,

 Thanks for prompt response. 

For column E & I works fine.

But look at formula of col. H

Column Name : Total Amount (H)

=IF(D2>0,SUM(F2:G2),0)

Its requires sum of F2:G2.  isn't? 

you suggested as:

H = IF('Table'[D]<=0,0,DIVIDE('Table'[C],'Table'[D]))

Please advice.  Thank you

[smpa01]

@sdhn 

_H = IF('Table'[D]>0,'Table'[F]+'Table'[G],0)

[sdhn]

H = IF('Table'[D]>0,'Table'[F]+'Table'[G],0)

I am getting following message:

<pi>A circular dependency was detected: TABLE[Column], TABLE[Column E], TABLE[Column].</pi>

We created Column E earlier as:

E = IF('Table'[D]<=0,0,DIVIDE('Table'[C],'Table'[D]))

  Thanks 

[smpa01 · Accepted solution]

@sdhn  take a look here

[sdhn]

Is it possible , I can send you a sample source file?  

Still not working for me.    Thanks 

[smpa01]

@sdhn  yes