Forum Discussion
"if" function in Power Query not working properly
Good day, I have a power query set up that is giving me the number of days between task completions during a large project. However, I am missing the time from the last completed task until "today"...
If the "if" function in Power Query is not working properly, ensure your syntax is correct. The basic structure is:
powerquery
Copy code
if [condition] then [result1] else [result2]
Common issues include missing "else" statements or incorrect comparisons (e.g., using "=" instead of "=="). Double-check your syntax and conditions.
powerquery
Copy code
if [condition] then [result1] else [result2]
Common issues include missing "else" statements or incorrect comparisons (e.g., using "=" instead of "=="). Double-check your syntax and conditions.
mickhence Sorry, but I don't know what you mean. I know how 'if' works in PQ.