Date Formats
Question
-
Hello,
I have just exported the Microsoft O365 Roadmap into Excel. I need to find a way in PowerBi using DAX to ensure the dates are in Date format. Currently they are as follows :
I wrote something like this
Month = IF('Microsoft365RoadMap_Features_10-09-2019'[Release - Copy.1] = "Q1", "March",
IF('Microsoft365RoadMap_Features_10-09-2019'[Release - Copy.1] = "Q2", "June",
IF('Microsoft365RoadMap_Features_10-09-2019'[Release - Copy.1] = "Q3", "October",
IF('Microsoft365RoadMap_Features_10-09-2019'[Release - Copy.1] = "Q4", "December",
IF('Microsoft365RoadMap_Features_10-09-2019'[Release - Copy.1] = "January", "January",
IF('Microsoft365RoadMap_Features_10-09-2019'[Release - Copy.1] = "Febuary", "Febuary",
IF('Microsoft365RoadMap_Features_10-09-2019'[Release - Copy.1] = "March", "March",
IF('Microsoft365RoadMap_Features_10-09-2019'[Release - Copy.1] = "April", "April",
IF('Microsoft365RoadMap_Features_10-09-2019'[Release - Copy.1] = "May", "May",
IF('Microsoft365RoadMap_Features_10-09-2019'[Release - Copy.1] = "June", "June",
IF('Microsoft365RoadMap_Features_10-09-2019'[Release - Copy.1] = "July ", "July",
IF('Microsoft365RoadMap_Features_10-09-2019'[Release - Copy.1] = "August", "August",
IF('Microsoft365RoadMap_Features_10-09-2019'[Release - Copy.1] = "September", "September",
IF('Microsoft365RoadMap_Features_10-09-2019'[Release - Copy.1] = "October", "October",
IF('Microsoft365RoadMap_Features_10-09-2019'[Release - Copy.1] = "November", "November",
IF('Microsoft365RoadMap_Features_10-09-2019'[Release - Copy.1] = "December", "December")
)))))))))))))))Which kind of worked, but i am aware this is not best practice.
How can i get the dates in the excel sheet into a proper date format so i can transform them in a date type column?
Thanks in advance.
- Edited by VStar19 Wednesday, October 9, 2019 2:47 PM Type
- Moved by Ehren - MSFTMicrosoft employee Wednesday, October 9, 2019 9:56 PM DAX question
