Solved: Data format issue

Anonymous · ‎09-10-2019

Hi,

i have a column in data set with format 1.2017 (as january 2017) but power BI reads it as 12-1899...?? how can i make it so is it read as january 2017?

Thanks!

MatejZukovic · ‎09-10-2019

Hi @Anonymous ,

you can create new column, replace "." with "-" and convert Data type to Date.

Month = SUBSTITUTE('Table'[Date],".","-")

Modelling:

Data Type : 'Date'

Format : MMMM yyyy

Hope it helps,

Matej

View solution in original post

MatejZukovic · ‎09-10-2019

Hi @Anonymous ,

you can create new column, replace "." with "-" and convert Data type to Date.

Month = SUBSTITUTE('Table'[Date],".","-")

Modelling:

Data Type : 'Date'

Format : MMMM yyyy

Hope it helps,

Matej

Anonymous · ‎09-10-2019

thanks, work fine.

v-eachen-msft · ‎09-25-2019

Hi @Anonymous ,

If your issues are solved, you could accept the reply you like.

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

AlB · ‎09-10-2019

Hi @Anonymous

You can also do it in the query editor without the need for a new column. Just click on the column with the right button of the mouse, choose "Replace value" and replace "." with "-". Then change type of the column to Date and that should be it