Forum Discussion

ilcaa72's avatar
ilcaa72
Icon for Helper IV rankHelper 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
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi ilcaa72,

 

You could have a reference of this similar thread which use M query to convert YYYYMM to date type.

 

There are two solutions in that thread, you could choose one the more efficient.

 

Best  Regards,

Cherry