Forum Discussion
Applicable88
Impactful Individual
Impactful IndividualCreate 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 1...
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.