The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi All,
My asks always seem to be relatively simple for the experts on this forum. My (hopefully simple) question can be displayed in the attached picture. What I am trying to do in the query editor is take the dates in my Date table and apply them to each unique part number in Table1 to get Table2 in the attached picture.
Is this possible? Thanks in Advance!
Solved! Go to Solution.
Hi @Anonymous
You seem to need a crossjoin of the two tables. Check this out:
https://exceleratorbi.com.au/cross-join-with-power-query/
Hey,
basically the answer is in a way simple, but also by no measn obvious 🙂
Here are some screenshots how to expand the Calendar table with Part Number column from the Parts table.
Select the Calendar table and choose the command "Custom Column" from the Add Column menu:
And just type the name of the Parts table ...
It does not matter how you name the column, after you choose OK, the Calendar table should look like the:
just hit the "expand" icon, and the next dialog will look like this:
This dialog allows to select the columns you want to "select" from the Parts table.
Personally I prefer to deselect naming option, but this is my personal taste. After choosing "OK" you're done ...
You're done!
Please be aware that this is the simplest of all possible joins, creating a cartesian product of combinations. This often is quite useful, but be sure that you want what you get, meaning you should consider if the result is also valid if the rows in both tables are not unique ...
Regards,
Tom
Hey,
basically the answer is in a way simple, but also by no measn obvious 🙂
Here are some screenshots how to expand the Calendar table with Part Number column from the Parts table.
Select the Calendar table and choose the command "Custom Column" from the Add Column menu:
And just type the name of the Parts table ...
It does not matter how you name the column, after you choose OK, the Calendar table should look like the:
just hit the "expand" icon, and the next dialog will look like this:
This dialog allows to select the columns you want to "select" from the Parts table.
Personally I prefer to deselect naming option, but this is my personal taste. After choosing "OK" you're done ...
You're done!
Please be aware that this is the simplest of all possible joins, creating a cartesian product of combinations. This often is quite useful, but be sure that you want what you get, meaning you should consider if the result is also valid if the rows in both tables are not unique ...
Regards,
Tom
This works perfect. Thank you very much.
Hi @Anonymous
You seem to need a crossjoin of the two tables. Check this out:
https://exceleratorbi.com.au/cross-join-with-power-query/
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
248 | |
123 | |
111 | |
78 | |
74 |