Forum Discussion
Solved
IF formula not working when creating a custom column
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", ...
The IF function is different in Power Query. Try this:
if [Training record completed date] > [training record Due Date] then "Yes" else "No"
That worked thank you so much!