Forum Discussion
Extract date from date and time
Hello Anonymous ,
Click at the date time column and then in the add column tab go to the date tab then click at date only and it will give you the date within each row.
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos👍
Hello Anonymous ,
Click at the date time column and then in the add column tab go to the date tab then click at date only and it will give you the date within each row.
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos👍
While this does visually cleanup the data point, isn't the time data still present and simply hidden? So if they are specifically referencing date values via dax in a downline use case there could be issues as the data isn't *exactly* as is needed, right?
The advanced editor entry I used to get to this looks like this:
Add_Start_of_Day = Table.AddColumn(Changed_Typ", "Start of Day", each DateTime.Date(DateTime.From([DateTime])), type date)