Forum Discussion
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!
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
If it were me, I would build a reverse lookup table. First build a calendar at the day level, that has month and week numbers. Then filter to keep (say) Mondays. This is the reference table that can be joined back against the source