none
Date Formats RRS feed

  • 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. 


    Wednesday, October 9, 2019 2:46 PM

All replies