Forum Discussion

BossCo's avatar
BossCo
Icon for Helper II rankHelper II
5 years ago
Solved

PowerQuery: We cannot apply field access to the type Function.

Hi everybody,   I'm not very familiar with M, but I'm try to add a new column using a very simple expression:   if Date.Month [MyDate] < 5 then Date.AddDays ([MyDate], 365) else [MyDate]   Appa...
Need Help
  • HotChilli's avatar
    HotChilli
    5 years ago

    Date.Month is a function so you need to put the parameter in brackets.  That will move you on a bit

BossCo's avatar
BossCo
Icon for Helper II rankHelper II
5 years ago

Thanks a lot! It works