Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I am trying to compare two date columns to see if one is greater than the other. The formula I am trying to use is:
=IF([Training record completed date]>[training record Due Date], "Yes", "No")
The error message I get it Expression.Error. The name 'IF' wasn't recognised. Make sure it's spelled correctly.
I have no clue as to why it isn't working. Please can anyone offer me a solution?
Thanks
Nikki
Solved! Go to Solution.
The IF function is different in Power Query. Try this:
if [Training record completed date] > [training record Due Date] then "Yes" else "No"
Proud to be a Super User!
That worked thank you so much!
The IF function is different in Power Query. Try this:
if [Training record completed date] > [training record Due Date] then "Yes" else "No"
Proud to be a Super User!
User | Count |
---|---|
89 | |
75 | |
69 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
74 | |
60 | |
59 |