Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
102 | |
79 | |
72 | |
65 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |