Manage relationship

[ktkpatra]

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

[ktkpatra]

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

[v-jayw-msft · Accepted 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

[amitchandak]

@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