IFNULL function similar to Tableau

[Anonymous]

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

[Anonymous · Accepted solution]

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])