Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |