Mixed granularity data model (Summary and Detail table of transaction)

[learner_23]

Hi,

I have two table one is summary level sales data and another is transactional level data. I'm getting many to many in data model.

Can you help on how to create a data model when we have mixed granular level data like this.

Appreciate your help!

[Anonymous · Accepted solution]

Hi @learner_23 

You need an intermediate table like this:

My sample:

Create a calculated table as follows

ID = VALUES(Table1[ID])

Output:

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vanessafvg]

please provide sample data (in text form) with the expected solution.