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

Leon Tomšič 1 Reputation point


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.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,982 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Ehren (MSFT) 1,781 Reputation points Microsoft Employee

    Hi there. Power Query is no longer supported here on Q&A. Please post your question over on instead.

    0 comments No comments