Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Solved! Go to Solution.
Date.Month is a function so you need to put the parameter in brackets. That will move you on a bit
Thanks a lot! It works
Date.Month is a function so you need to put the parameter in brackets. That will move you on a bit
User | Count |
---|---|
134 | |
71 | |
70 | |
54 | |
52 |
User | Count |
---|---|
205 | |
95 | |
63 | |
61 | |
54 |