Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I'm able to convert my column using the formula below. It converts the column to a text data type. and results into a date/time field. I want the field to display as date only. Is this possible? Thank you.
#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [startDate]/1000)
Solved! Go to Solution.
@mdubose , if the conversion is correct. Just change the data type to date in power query
or use in power query
DateTime.Date([You Date Time COlumn])
@mdubose , if the conversion is correct. Just change the data type to date in power query
or use in power query
DateTime.Date([You Date Time COlumn])
User | Count |
---|---|
106 | |
86 | |
81 | |
74 | |
71 |
User | Count |
---|---|
112 | |
101 | |
96 | |
74 | |
67 |