Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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://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
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://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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |