topic Re: How to create 1 date column from 7 date columns in DAX Commands and Tips

How to create 1 date column from 7 date columns

LYBridges — Fri, 12 Jul 2024 16:42:40 GMT

Hello,

I'm trying to use DAX to create a new date column aggregating 7 date columns.

If Date1 is not blank then Date1.

If Date1 is blank then Date2.

If Date2 is blank then Date3.

On through all 7 date columns.

Can anyone point me in the right direction? Power BI newbie, any assistance is greatly appreciated!

DataInsights — Fri, 12 Jul 2024 17:19:10 GMT

Try the COALESCE function which returns the first non-blank argument:

COALESCE ( Table[Date1], Table[Date2], Table[Date3] ... )

LYBridges — Fri, 12 Jul 2024 17:50:21 GMT

That worked! Thanks so much. COALESCE is new for me, but will be very helpful for other situations.