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!
Check out the changes to the Power BI Community announced at Build.
Find out more about the May 2023 update.
Visit our Data Stories Gallery and give kudos to your favorite Data Stories.