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_ ...
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

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

AllanBerces's avatar
AllanBerces
Post Prodigy
2 months ago

Hi pallavi_r thank you very much working as i need.