Forum Discussion

BossCo's avatar
BossCo
Helper 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]

 

Apparently, I'm missing out something since it returns me the following Expression Error:

 

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

 

Where am I going wrong?

 

Thanks everybody!

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

2 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion

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