I have a table like so...
I would like this result....
Many Thanks all I will accept your solution if correct tomorow morning!
Go to Solution.
@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])
View solution in original post
@Greg_Deckler Happy days that's perfect thank you very much!
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.