Francesco Bergamaschi

Unlock the power of Composite Models in Power BI to bridge the gap between self-service and enterprise reporting. In this session, we’ll explore how to enrich local data with enterprise Power BI semantic models, giving self-service Power BI developers the best of both worlds—a hybrid solution that combines flexibility…

DAX is a simple language (but not easy at all). Its five pillars, though, need to be clearly understood in order not to get confused when they, as inevitably happens, interact between them in your measures, calculated columns or calculated tables.

DAX is a simple language (but not easy at all). Its five pillars, though, need to be clearly understood in order not to get confused when they, as inevitably happens, interact between them in your measures, calculated columns or calculated tables.

CALCULATE is the most powerful DAX function as it allows to manipulate the filter context at your will, like in the case of time-intelligence calculations. Yet, the function is not easy to understand unless its full algorithm is completely clear. In this session the algorithm will be disclosed together with a set of examples of increasing complexity with the aim to reach a complete, yet guided and gradual, understanding of the CALCULATE function. At the end of the session a full picture of CALCULATE will be in the participants' hands.

Visual Calculations (VCalcs) are not only a new Power BI feature that can facilitate access to Power BI for DAX beginners, but also – digging deeper – a complex calculation system based on a new DAX evaluation context: the Visual Context (VContx). If you are not satisfied with the built-in formulas created in VCalcs…

CALCULATE is the most powerful DAX function as it allows to manipulate the filter context at your will, like in the case of time-intelligence calculations. Yet, the function is not easy to understand unless its full algorithm is completely clear.