Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello!
Very stupid question. Seems super simple, but cannot find the solution. Just trying to add a date manually into a column in a table. All I need to add is a column with a specific date (e.g. 31/Dec/2019) which will have the same value in all the column.
I try adding a custom column but it does not recognize the DATE function, neither does it recognize a simple =DD.MM.YYYY
Thanks!
Solved! Go to Solution.
In DAX,
DATE(2019,12,31)
In Power Query, I would just do something like:
="12/31/2019"
And then just convert the column to be a date.
Many thanks! Works perfectly!
MS3
Great! Glad to hear it!
In DAX,
DATE(2019,12,31)
In Power Query, I would just do something like:
="12/31/2019"
And then just convert the column to be a date.
It works, thank you for your help 🙂
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |