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.
I am having trouble in relationship. I would like to know relationship in my Power BI desktop have same dataset with different year with 2 different file. I want make relationship Sales order number from both the dataset. Is it possible or something need to other way.. please let me know or call me to explain you more. Your help will be highly appreciated. thanks
Solved! Go to Solution.
Hi @ktkpatra ,
Please refer:
SALES_DOC = DISTINCT(
UNION(
ALL('2020 ENI'[Sales Document]),
ALL('2020 HV_MH'[Sales Document]),
ALL('2021 ENI'[Sales Document]),
ALL('2021 HV_MH'[Sales Document])
)
)
Best Regards,
Jay
Thanks for your reply.
In same way Power BI desktop have same dataset with different year with 4 different file. I want make relationship Sales order number from all the dataset and getting error as "Operator or expression '() is not supported in this context" below. Could you please help me
OR
Hi @ktkpatra ,
Please refer:
SALES_DOC = DISTINCT(
UNION(
ALL('2020 ENI'[Sales Document]),
ALL('2020 HV_MH'[Sales Document]),
ALL('2021 ENI'[Sales Document]),
ALL('2021 HV_MH'[Sales Document])
)
)
Best Regards,
Jay
@ktkpatra , create a Bridge table, if that can help
https://www.seerinteractive.com/blog/join-many-many-power-bi/
Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19
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 | |
105 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |