David Kofod Hanna

DAX is a simple language (but not easy at all). Its pillars, though, need to be clearly understood in order not to get confused when they interact between them in your measures, calculated columns or calculated tables. In this session the five DAX pillars (filter context, row context, context transition, iterators and expanded tables) will be explained, with examples, one by one first and then in interaction between them. Examples will be in increasing complexity order.

“You do not rise to the level of your goals, you fall to the level of your systems.” We all have a vision for great documented Power BI solutions - but well to often we push it at the end, forget it or can't remember it. This session will suggest a well-designed Power BI documentation systems that lead to progress, even when motivation is low. In this session, you'll get hands-on methods for making documentation a natural part of your Power BI workflow. We'll explore Power Query metadata, Table Groups and scripting in Tabular Editor, INFO.VIEW DAX functions, external tools, model layout views, TMDL view documentation, VertiPaq Analyzer in DAX Query views, Semantic Link Labs, and JSON theme documentation. Everything is tied together in a user-friendly, accessible app – where the end user meets the documentation directly. This isn’t just inspiration – it’s a system you can take home and apply. A Power BI documentation system – not just an afterthought

This session will guide you through 20 tips and tricks on how to leverage Power Query and the (M)agic through UI, hidden gems and code to boost your use and understanding of Power Query. Whether you're just starting or looking for that one extra trick to optimize your workflow, this session covers it all.