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.
Hello everyone,
I have two tables that I need to relate by columns (Ref, Start and End), but the beginning and end of both tables are different, I was wondering if there is any way to make the intersection between the two tables to be able to make the relationship.
Model:
. The lines (XX_00072 0 4) and (XX_00072 4 6) report to the line (XX_00072 0 6.96) because the beginning or the end intersects.
. The lines (XX_00072 6 11) and (XX_00072 11 12) report to the line (XX_00072 6.96 13.61) because the beginning or the end intersects.
Any way to do this?
Dataset Table 1:
Dataset Table 2:
Note It is not possible to merge between the tables because table 1 has 300,000 rows and Table 2 has 4000 rows
Solved! Go to Solution.
Hi @Anonymous ,
You can append these two tables as new query in Power Query Editor with following codes just as suggested by @VijayP :
let
Source = Table.Combine({#"Table 1", #"Table 2"}),
#"Sorted Rows" = Table.Sort(Source,{{"Start", Order.Ascending}})
in
#"Sorted Rows"
Best Regards
Hi @Anonymous ,
You can append these two tables as new query in Power Query Editor with following codes just as suggested by @VijayP :
let
Source = Table.Combine({#"Table 1", #"Table 2"}),
#"Sorted Rows" = Table.Sort(Source,{{"Start", Order.Ascending}})
in
#"Sorted Rows"
Best Regards
@Anonymous
i think we cannot create relation ship between these tables as the ref column in both the tables is multiple times and other data is not matching.
only thing you can use Full outer and merget the tables!
Proud to be a Super User!
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |