Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
how can I create new rows in power query. A join and a union is not whats working here, since there is no match on both sides.
I have a calendar:
Date | Month | |
08.11.2022 | 11 | |
09.11.2022 | 11 | |
10.11.2022 | 11 | |
11.11.2022 | 11 | |
12.11.2022 | 11 | |
13.11.2022 | 11 | |
14.11.2022 | 11 | |
15.11.2022 | 11 | |
16.11.2022 | 11 |
And I need the categorie a,b and c for every date:
Date | Month | Category | ||
08.11.2022 | 11 | a | ||
08.11.2022 | 11 | b | ||
08.11.2022 | 11 | c | ||
09.11.2022 | 11 | a | ||
09.11.2022 | 11 | b | ||
09.11.2022 | 11 | c |
and so fourth...
Hope someone know if there is any functionality within Powerquery for it.
Thank you very much in advance.
Best.
Solved! Go to Solution.
Do a full out join between the tables using the Merge Function in Power Query. They will need to be of the same data type, so change the date first to Text then merge then change date back to Date type.
You could create a field in both tables that have the same value and then merge on that field, e.g. TableA[Key] = TableB[Key] where Key is the value "ABC" in both.
Do a full out join between the tables using the Merge Function in Power Query. They will need to be of the same data type, so change the date first to Text then merge then change date back to Date type.
You could create a field in both tables that have the same value and then merge on that field, e.g. TableA[Key] = TableB[Key] where Key is the value "ABC" in both.
Check out the July 2025 Power BI update to learn about new features.