Forum Discussion
stribor45
3 years agoPost Prodigy
DATE 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!
stribor45
3 years agoPost Prodigy
that worked but I don't think that was mentioned Date . Why do you need #?
- sevenhills3 years agoSuper 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!