Forum Discussion
joshua1990
Post Prodigy
Post ProdigyCreate 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 ...
johnt75
Super User
Super UserIt 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.