Forum Discussion
Convert text to Date
Hi everyone, How can I convert Year-month from text to Date? I tried: YearMonth_Date = DATE(LEFT(Table[YearMonth], 4), RIGHT(Table[YearMonth], 2), 1) but it's not work Thank you
U can simply change text to date format in PQ if that does not work. There are also plenty of solutions to this question online. Please google before posting.
See for instance:
Solved: Converting text year to date in Power Query - Microsoft Power BI Community
Solved: Convert string to date - Microsoft Power BI Community
Solved: Converting from Text to Date - Microsoft Power BI Community
There are loads more online.
"Text to date Power BI"