Looking back at the last 20 weeks of Power Query Videos (QE) we would advise going back and rewatching them periodically, there’s a treasure trove of content there including unpivoting, aggregation and functions. It would not be possible to do it all justice without going through it all again.
As you learn to do more with DAX you will invariable arrive at a requirement for an X-function, we deliberately dropped an AVERAGEX ( ) in recently, today we show you how X-Functions work and talk about what they are actually doing. Leading into a discussion around the use of Calculated Columns.
