Forum Discussion

EmilyM2019's avatar
EmilyM2019
Helper II
6 years ago
Solved

DAX for date column

Hi all,   I am stuck with a DAX if someone can help me.   I have a table with 2 date columns, Column A and Column B.    I want a new column (Column C) that will look and see if there is a value...
Help me please
  • ibarrau's avatar
    ibarrau
    6 years ago

    I'm sorry I forget to add the null cases too. Try this:

    if [ColumnA] = "" or [ColumnA] = null then [ColumnB] else [ColumnA]

    Regards, 

EmilyM2019's avatar
EmilyM2019
Helper II
6 years ago

Hi,

 

Thanks for coming back to me. I'm now trying to do this in Power query but it hasn't worked. Using the add custom column option I have done:

 

= Table.AddColumn(#"Renamed Columns2", "Custom", each if[Column A]=""then[Column B]else[Column A])

 

and it isn't working. The only value that is returning in the new custom column is the value of column A.

 

Any ideas? 

ibarrau's avatar
ibarrau
Super User
6 years ago

I'm sorry I forget to add the null cases too. Try this:

if [ColumnA] = "" or [ColumnA] = null then [ColumnB] else [ColumnA]

Regards, 

  • EmilyM2019's avatar
    EmilyM2019
    Helper II
    6 years ago

    Thank you, this has worked, hurrah.

     

    Just to build on this how would I do:

     

    If column A and column B are blank then return todays date?

    • ibarrau's avatar
      ibarrau
      Super User
      6 years ago

      Well it should be similar

       

      if [ColumnA] = "" or [ColumnA] = null then
if [ColumnB] = "" or [ColumnB] = null then 
DateTime.LocalNow() 
else [ColumnB] else [ColumnA]

       

      You can continue adding if statements in the "then" or "else" in case you need them.

      Regards,

      • EmilyM2019's avatar
        EmilyM2019
        Helper II
        6 years ago

        Thanks for your help.