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 got a table who contains several ID adress, like, one id for shipping / sales / paiement. And i got just on table adress.
But i can join several times two tables exact ?
Please need help 😞
Solved! Go to Solution.
Hi @Anonymous ,
There is only one active relationship between two tables. If you want an additional relationship when a relationship has been built, the new relationship will be inactive and the relationship line is dotted line. As the official document said:
Once you've connected two tables together with a relationship, you can work with the data in both tables as if they were a single table, freeing you from having to worry about relationship details, or flattening those tables into a single table before importing them.
For how to build relationships,please refer to:
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
There is only one active relationship between two tables. If you want an additional relationship when a relationship has been built, the new relationship will be inactive and the relationship line is dotted line. As the official document said:
Once you've connected two tables together with a relationship, you can work with the data in both tables as if they were a single table, freeing you from having to worry about relationship details, or flattening those tables into a single table before importing them.
For how to build relationships,please refer to:
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your answer ! I try the second way, but i got 8 table in this way, i think it's way to much, and i have to wait maybe 1 minute when i want rename a field.
@Greg_Deckler In the first way, how can i use this ? Because i need to display the four adress in the same table.
@Anonymous Two ways to go about this. One, you can create two relationships. One will be inactive and you can use USERELATIONSHIP in a measure to force which one you want to use. Second way, duplicate your address table creating two "scenario" dimensions such as a Shipping dimension and Accounting dimension.
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |