Concatenate values to date format (yyyy-mm) returns error

[Anonymous]

Hi,

The yellow is the starting point but Power BI does not recognize this date format. I've then concatenated orange and green to get the red (New date). However, is returns error once column is changed to date.

any suggestion why this format is not accepted?

[Anonymous]

Hi @Anonymous ,

You can clean the data in power query with following steps:

Sample:

Add Column from examples(Try writing a few more lines of sample data to make sure it's correct):

Change data type:

Visual:

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

@Anonymous 

pls try this

Column = date(left('Table'[year with dash],4),'Table'[Month],1)

[Anonymous]

Thank you for your effort. However, I'm stille getting the error.

[ryan_mayu · Accepted solution]

i saw you have year column , then change it to year

date(year, month, 1)