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...
You need a "try" in front of the "if".
The syntax is:
try [THIS] otherwise [THAT]
where [THIS] is what you want to calculate i.e. your entire "IF" statement, and [THAT] is what you want to display if your calculation fails for any reason.