Dating issues - Wk.Year & converting to an actual date

[Anonymous]

Hi there,

Have dates in a wk.year format, that upload as decimal numbers. Trying to convert to months, but cannot for some reason. Is there either a way to convert using formula, or a second option is can you get a custom column in PowerQuery to look up to another table and reference that? Like vlookup?

Have tried replacing the "." with a "/" but it only reads that as day rather than a week, plus once you go above 12 (like week 43 etc) it looses its life in panic

 

[v-lili6-msft · Accepted solution]

HI, @Anonymous 

You could use Merge function in PowerQuery,

With a merge query, you can achieve similar goals to the Excel VLOOKUP function. VLOOKUP lets you do a join between two data sets that are in Excel. With a merge, you can join two data queries that are in Excel or an external data source. In addition, the Merge feature has an intuitive user interface to easily relate the two join tables.

https://support.office.com/en-ie/article/merge-queries-power-query-fd157620-5470-4c0f-b132-7ca2616d17f9

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

https://businessintelligist.com/2015/09/15/power-bi-desktop-merge-query-options/

You need to define a Dim date table, then do merge function with it.

Best Regards,

Lin