Forum Discussion

Ania's avatar
Ania
New Member
8 years ago
Solved

Power BI

Hi, In my model I got column "Date" with two types of dates: "day-month-year" and "month/day/year". What would be the formula to unify the date format? I know how do do that in SQL ( IF(`date` RLI...
  • waltheed's avatar
    waltheed
    8 years ago

    You can use the DATE function for that, together with MID.

     

    MyDateColumn = date("2018", "4", "17")   this returns a data value.

     

    Fill in the Year, Month and Day by doing a MID function on your string values. 

    e.g. MyYear = MID("25/04/2018",7,4)    this returns 2018. 

     

     

waltheed's avatar
waltheed
Icon for Impactful Individual rankImpactful Individual
8 years ago

You can use the DATE function for that, together with MID.

 

MyDateColumn = date("2018", "4", "17")   this returns a data value.

 

Fill in the Year, Month and Day by doing a MID function on your string values. 

e.g. MyYear = MID("25/04/2018",7,4)    this returns 2018.