Flat to Star Transformation using DAX Query

By Avi Singh [Twitter]
As I have started working with clients around training/consulting, I am surprised by how often I find tables FlatToStar_RockyIV that have been flattened, i.e. the data tables have been combined (joined) with lookup tables, to produce a really wide table with everything and the kitchen sink in it. Maybe that’s to be expected; after all that is the modus operandi when working in Excel. That’s the first habit that I try to break…
Continue reading at PowerPivotPro…