I'm trying to run some reports but the date column is seen as text and I need to convert the string to a date. I don't have access to the db, just what is pulled into PBI.

Current format:YYYYMM

So I need to convert that string format to a date format of month and year.

Any suggestions?