Forum Discussion
Need Help with Data Modeling and Relationships
efogelberg , TableB need double unpivot(Company and claims) and tableC need unpivot(claims)
After that, you can have a common dimension date, company
Power Query Magic: Double Unpivot and Reshape Data for Analysis in Power BI| Unpivot Column Set: https://www.youtube.com/watch?v=Diazpx1Nfec&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=1
Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g
Thank you, I will give this a shot. As for the different in calculation, will this resolve that as well? Currently, it is calculating the Quarterly Rate as a sum of all individual rates (rate is # claims x 100,000/# customers) for that quarter rather than summing the number of claims that quarter and dividing by total number of customers for that quarter. Essentially it's summing the individual calculations rather than doing a new calculation.
