Forum Discussion

fluppo's avatar
fluppo
Frequent Visitor
7 years ago

Many to Many Relationship

Dear community I try to split a statement of accounts to functions ... and got completely stuck. I have two tables with a many-2-many relationship. I did set up a bridge table to get the relatio...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi fluppo ,

 

 

You can post the data, pbix onto OneDrive / GoogleDrive and share the link here. Please also let know the ouput you expect.

 

Cheers

 

CheenuSing 

    • fluppo's avatar
      fluppo
      Frequent Visitor
      7 years ago

      I managed to find a possible solution based on the post from Cherry:

      /Multiply-two-tables-with-a-many-to-many-relationship

       

      However, I don't really understand the solution and would appreciate if you could help me with the following question:

      The measure creates a table on the fly, right. Is this an efficient solution? When I apply it to a mid-sized set of data it is calculting for quite some time (I might be too impatinent though)

      Are there alternatives methods?

       

      Best regards

      F.