Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Creat more than one relationship

Hello,   I have created relationships between 3 sheets using a date table (green).   The 3 sheets also have similar data in the column BZ_20, BZ_21, BZ_Soll (yellow) which is the number of the Bu...
Need Help
  • PC2790's avatar
    PC2790
    5 years ago

    Power Query --> Append Queries--> Append as new(it will constitute of the all the columns from your other tables)

    In the transformation steps, remove all the columns those are not required -->Remove duplicates and your table is ready to be used as slicer.

v-xulin-mstf's avatar
v-xulin-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous

 

You can use USERELATIONSHIP function to apply more then one active relationship.

For more information, you refer the following blog.

https://blog.pragmaticworks.com/powerbi-dax-function-userelationship-explained

If you still have some question, please don't hesitate to let me known.‌‌

 

Best Regards,

Link

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!