Forum Discussion
Anonymous
3 years agoNot applicable
M Query Returns Error for Calculated column referencing null values of date column
I have a calculalted M query column Receive and Close Date Flag = if ([Actual Closed Date] >= #"Parameter Date Closed Start Date" or [Date Received] >= #"Parameter Date Received Star...
AndrewPF
3 years agoHelper V
Use this:
try if([Actual Closed Date] >= #"Parameter Date Closed Start Date" or [Date Received] >= #"Parameter Date Received Start Date" and [Deal Status Display] = "Open") then "True" else "False" otherwise null
see also:
Anonymous
3 years agoNot applicable