Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
2 months ago
Solved

IF Condition

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_SubtableFinal
000
0 0
000
0 0
0 0
0 0
000
1 1
1 1
1 1
100
100
100
100
100
100
100
1 1
1 1
1 1
1 1
Need Help
  • pallavi_r's avatar
    pallavi_r
    2 months ago

    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

3 Replies

  • pallavi_r's avatar
    pallavi_r
    Super User
    2 months ago

    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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 months ago

    Hi,

    Write this calculated column formula

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

    Hope this helps.