Hello,
I am trying to insert a conditional column in a Power Query. It needs to introduce a column with a value dependent on {Last Covid Test Date}; if the date is greater or equal with TODAY() date -7 it should read YES, if not it should read NO
I know how to do that in Excel, no idea though how to write the formula in M.
Could any of you please help?
Bookmarks