Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Applicable88
Impactful Individual
Impactful Individual

Create more rows in calendar table

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.

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Solution Authors