Sometimes data models can be confusing, but luckily Power Query’s powerful transformation capabilities can enable you turn that confusing data model into some awesome insight. Check out this example where I use Power Query to run some analysis on fact tables of different granularities!

https://tessellationtech.io/creating-bridge-tables-in-power-query/

*this article was originally published on tessellationtech.io