Create a date from year, month, month week and day from that week

Question

Hi,

I have a Power Query table with 4 columns:

• Year
• Month
• Week in that month: TEDEN 1, TEDEN 2, TEDEN 3, TEDEN 4, TEDEN 5
• day in that week

Is there a way I can create a date in a separate column from this data? Results that don’t return an actual date can just be empty.

Answer 1

Hi there. Power Query is no longer supported here on Q&A. Please post your question over on https://aka.ms/PQCommunity instead.