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