Forum Discussion

ktkpatra's avatar
ktkpatra
Frequent Visitor
4 years ago
Solved

Manage relationship

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 ...
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
ktkpatra
Frequent Visitor
4 years ago

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

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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