Forum Discussion
Solved
power query, Date Type
i opened a table in power Query, the column is date data and comes in as a number field... 201805 201804 201803 when i convert to date it changes it to, 7/8/2452. Obviously wrong. What is ...
In reports tab use DAX: create a new column Date = FORMAT(Table1[Column1],"YYYY-MM")
In reports tab use DAX: create a new column Date = FORMAT(Table1[Column1],"YYYY-MM")