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