topic Re: If null, then use other columns values (Easy IF statement maybe?) in DAX Commands and Tips

If null, then use other columns values (Easy IF statement maybe?)

Ttaylor9870 — Mon, 14 Nov 2022 16:59:25 GMT

Hi All,

I have a table like so...

I would like this result....

Many Thanks all I will accept your solution if correct tomorow morning!

Taylor

Greg_Deckler — Mon, 14 Nov 2022 18:26:27 GMT

Ttaylor9870 So if it is really "null" as in the word "null" it would be:

Close Date Column = IF([Order Date] = "null",[Date Secured],[Order Date])

if the "null" in your data represents a "blank" the it is:

Close Date Column = IF([Order Date] = BLANK(),[Date Secured],[Order Date])

Ttaylor9870 — Tue, 15 Nov 2022 09:12:51 GMT

Greg_Deckler Happy days that's perfect thank you very much!