Many to many relationship in PowerPivot Data Model

Hi,

I have above 2 tables. Parent Child mapping & simple fact table with data at parent level for each date. I would like to see the report where-in I ll have parent data propagated down to their respective children based on Timeline selection. I have pulled those table in Data Model. But I am unable to create relationship between them. This is because both table have duplicate values (Parent value- Sys1) which is nothing but having Many-to-Many relationship which is directly not possible in Data Model.   

Even I can not create a merged tables because both these tables have million of records.

Can anyone suggest me how should I achieve this above report where-in I want children to show their Parent's data along with timeline?


May 26th, 2015 1:19am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics