Forum Discussion
stribor45
Post Prodigy
3 years agoDATE error
Can someone suggest as to what I am doing wrong when creating calculated column? I am adding this formula = DATE(2023,1,1) but I am receiving this error.
- 3 years ago
The link you had is DAX expression syntax.
whay you are trying to do is in M Query, which the syntax is
https://learn.microsoft.com/en-us/powerquery-m/sharpdate
Hope this clarifies!
- stribor453 years ago
Post Prodigy
that worked but I don't think that was mentioned Date . Why do you need #?
- sevenhills3 years ago
Super User
The link you had is DAX expression syntax.
whay you are trying to do is in M Query, which the syntax is
https://learn.microsoft.com/en-us/powerquery-m/sharpdate
Hope this clarifies!