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

Leon Tomšič 1 Reputation point
2022-04-15T06:28:42.537+00:00

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

193308-slika.png

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.
35,513 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Ehren (MSFT) 1,781 Reputation points Microsoft Employee
    2022-04-29T18:05:55.93+00:00

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

    0 comments No comments