return value from other column if it is blank

[NickProp28]

Dear Community,

Here is my dataset, would like to know a dax if actual time is blank, will refer the date of DeliveryTime. (Only retreive Delivery time when Actual Time is blank)

Appreciate and thanks for your time help me on this matter.

Here the pbix: https://ufile.io/ymqjsspu

[amitchandak · Accepted solution]

@NickProp28 , Try new column

new column = coalesce([ActualTime],[DeliveryTime])

or
new column = if(isblank([ActualTime]),[DeliveryTime],[ActualTime])

[NickProp28]

Dear @amitchandak  @Greg_Deckler ,

Thanks for the help.

[Greg_Deckler]

@NickProp28 - Should be:

Column = IF(ISBLANK([ActualTime]),[DeliveryTime],[ActualTime])