Forum Discussion

RossC's avatar
RossC
Frequent Visitor
7 years ago
Solved

Date and time formatting

Hi I'm new here and trying to figure out DAX as I go, I have an issue with a Power BI Dashbard that I am trying to create from a downloaded report from an Old system, and I want to be able to refresh...
Need Help
  • themistoklis's avatar
    themistoklis
    7 years ago

    RossC

     

    The DAX formula in PowerBi will be pretty much the same as the one in Excel.

     

    Creata a new column and not measure and add the following code:

     

     

    datenew = MID('Table'[DateColumn], 7,2) & "/" & MID('Table'[DateColumn], 5,2) & "/" & LEFT('Table'[DateColumn],4)

     

    Then go to Modelling tab on top, select the datenew column and change the data type to Date

themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
7 years ago

RossC

 

The DAX formula in PowerBi will be pretty much the same as the one in Excel.

 

Creata a new column and not measure and add the following code:

 

 

datenew = MID('Table'[DateColumn], 7,2) & "/" & MID('Table'[DateColumn], 5,2) & "/" & LEFT('Table'[DateColumn],4)

 

Then go to Modelling tab on top, select the datenew column and change the data type to Date

  • RossC's avatar
    RossC
    Frequent Visitor
    7 years ago

    Thanks that worked perfectly!!! :smileyvery-happy: