Forum Discussion
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...
This is the code:
try if [Actual Date Closed] >= #"Parameter Date Closed Start Date" or [Date Received] >= #"Parameter Date Received Start Date" and [Deal Status Display] = "Open" then "True" else "False" otherwise null
It was Actual Date Closed, not Actual Closed Date, and there were some erroneous brackets
It is not working for me. Can you please update or test it out in the PBIX.
As an FYI, the cells showing as Error should display as False or True.