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 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

 

 

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

3 Replies

  • 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