Forum Discussion
Solved
Add a single-row, single-column table to another table (no relationship)
I have a 1x1 table that has a number I've generated. It will always be just one row.
I want to "broadcast" that value to an entire column of another table (i.e. create a column that is just that value).
Because it's a 1x1 table, there's no dimension that I can use to join it.
How can I do this?
This sounds like it should be exactly equivalent to cross-joining the two tables in Power Query:
https://learn.microsoft.com/en-us/power-query/cross-join
2 Replies
Chris_WhiteResolver II
This sounds like it should be exactly equivalent to cross-joining the two tables in Power Query:
https://learn.microsoft.com/en-us/power-query/cross-joinYes, it is! That's such a simple solution. Thank you.
