question

LeonTomi-7149 avatar image
0 Votes"
LeonTomi-7149 asked Ehren answered

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

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.


power-query-not-supported
slika.png (20.3 KiB)
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Ehren avatar image
0 Votes"
Ehren answered

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

5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.