Forum Discussion
Switch statement comparision datat type error
Hi, I have the following code Missed Deadlines =
SWITCH (
TRUE (),
'Maintenance Ticket System'[Status] = "Critical"
&& 'Maintenance Ticket System'[JobStarted]>1,"Missed...
The solution was because Job Started had a formula using datediff it seeemd to return text, even though the Job Started column was a whole number .. that didnt throw up an error.. however adding VALUE in front of the date diff on the job started column seemed to resolve the issue.
Check the types of the columns in Power Query, the issue could be there.