Forum Discussion
Create calculated column based on 2 columns from different table
Hi experts!
I need some advice what are the best practicies to complement 1 table by another table.
I have simple table that shows me the sales per article peer week:
| Year-Week | Article | Value |
| 2025-01 | A | 5 |
| 2025-01 | B | 5 |
And then I have another table th contains a text for each article and each week: Year Week | Article | Text
Now I would like to add the text as a column into the first one.
Is it the best way to do it via PQ and a JOIN on Year-Week and Article?
Or would you prefer DAX? And if so, how?
We are taling about more than 3Mio rows.
2 Replies
It is considered best practice to do required transformations as close to the source as possible. If the data is coming from a database you could do the join in SQL, if not then Power Query would be your next best bet. DAX would be a last resort, particularly for so many rows.
Hi joshua1990
Instead of creating a join in PQ or a calc column in DAX, I would make use of relationships.
