Forum Discussion
Anonymous
3 years agoNot applicable
Add Column from another table in Power Query editor without merging
Good Afternoon,
I have two tables, WO1_WorkOrderMaster & WO2_WorkOrderMaterialDetail. For some reason, WO1 has the WOduedate and the current order status but WO2 does not. Is there any way to add the Status and Date column from WO1 into WO2 without merging the two? Ive tried a merge and it runs too slow for me to use, I need the status and date in there so that I can order by date and filter out some of the statuses I dont want to look at. Essentially need to use something like a related() dax function but in power query editor instead. Is this possible?
Thank you in advance for any help/advice
1 Reply
- lbendlinSuper User
Whatever you do in Power Query will be much slower than what you can do in Power BI. Let the data model do the work for you.