IF Condition

[AllanBerces]

Hi good day, can anyone correct my IF calculated column 

Final = IF('Table01'[Subtable] = 0, 0, 'Table01'[Initial_)])

Current Result it turnout all 0

DESIRED OUTPUT

Initial_	Subtable	Final
0	0	0
0		0
0	0	0
0		0
0		0
0		0
0	0	0
1		1
1		1
1		1
1	0	0
1	0	0
1	0	0
1	0	0
1	0	0
1	0	0
1	0	0
1		1
1		1
1		1
1		1

[Ashish_Mathur]

Hi,

Write this calculated column formula

Column = if(Data[Subtable]==0,0,Data[Initial_])

Hope this helps.

[pallavi_r · Accepted solution]

Hi @AllanBerces ,

Please chech the below correct version and let me know if this works for you.

Corrected_Final = IF(ISBLANK('Data'[Subtable]), 'Data'[Initial_], 0)

Now with this version output is as provided in the snapshot below.

If it sees a blank: It pulls Initial_ value.

If it sees a 0: It recognizes the number and returns 0.

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,
Pallavi

[AllanBerces]

Hi @pallavi_r thank you very much working as i need.