Forum Discussion

ilcaa72's avatar
ilcaa72
Helper IV
8 years ago
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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

     

     

    In reports tab use DAX: create a new column Date = FORMAT(Table1[Column1],"YYYY-MM")

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi ilcaa72,

 

Have you solved your problem?

 

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

Best  Regards,

Cherry