Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

If one column is blank select another column

HI,    I am trying to work out the formula for this: if purchasing[Actual ship date] is blank select Purchasing[Confirmed ship date].    ie. PO number 26049 - Actual ship date = Blank, Confirmed ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    Write this calculated column formula

    Actual date = if(isblank(purchasing[Actual ship date]),purchasing[Confirmed ship date],purchasing[Actual ship date])

gadielsolis's avatar
gadielsolis
Icon for Resolver III rankResolver III
2 years ago

Hello,

 

Please try the following DAX:

 

If ( ISBLANK(Selectedvalue([Actual Ship date])),Selectedvale([Confirmed ship date]),Selectedvalue([Actual Ship date]))

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Unfortunately im getting 'too many arguments were passed'