Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

IFNULL function similar to Tableau

Hi All,

 

I am new to Power BI and have come here from Tableau background. I have a Tableau report that needs to be rebuilt in Power BI.

 

Do we have any function equivalent to IFNULL in Tableau?

 

I need to check for a measure called 'Deliveries' and if that is null, then I need to use the 'Manual Deliveries' in the caluclated field. My Tableau calculation goes like this.

 

IFNULL([Manual Deliveries], [Deliveries])

 

Can I get some help here?

 

Regards

Durga

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Never mind guys. I think I have got it like below and it worked.

     

     

    Delivered Quantity = IF(ISBLANK(im_dailydipsum_mx[deliveries]),im_dailydipsum_mx[manual_deliveries], im_dailydipsum_mx[deliveries])
     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Never mind guys. I think I have got it like below and it worked.

     

     

    Delivered Quantity = IF(ISBLANK(im_dailydipsum_mx[deliveries]),im_dailydipsum_mx[manual_deliveries], im_dailydipsum_mx[deliveries])