Forum Discussion

staruwo's avatar
staruwo
New Member
8 years ago
Solved

Convert column from Text to Date

Anyone knows how to convert week, month and year into a date format? For Example Week 1, Month 1, Year 2018 = 1/1/2018 Assume every week starts on Monday?   Thanks!
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi staruwo,

     

    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.

     

    If you still need help, you could convert the week, month, year to Whole number data type and use DATE function to create a calculated column.

     

    Column = DATE('Table'[Year],'Table'[Month],1)

     

    For another option, you may could try with M Query to convert week number to Date type. 

     

    Here is a similar thread you could refer to.

     

    Best Regards,

    Cherry

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

Hi staruwo,

 

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.

 

If you still need help, you could convert the week, month, year to Whole number data type and use DATE function to create a calculated column.

 

Column = DATE('Table'[Year],'Table'[Month],1)

 

For another option, you may could try with M Query to convert week number to Date type. 

 

Here is a similar thread you could refer to.

 

Best Regards,

Cherry