2a: Power BI

SUMMARIZE is a very powerful and very complex function to use. This article describes its internal behavior, and provides guidance on how to use it. If you

The context transition in DAX is the transformation of row contexts into an equivalent filter context performed by CALCULATE and CALCULATETABLE. Managing th

Compare all sharing methods for the Power BI content with their pros and cons and best practice use cases mentioned for each.

In this Power BI post we will take a closer look at the Pivot and Unpivot functionalities in Power Query in Power BI and the usefulness thereof.

Goofy - sticking to it.

One of the first concepts to learn in DAX is the difference between calculated columns and measures. This article shortly recap the differences.

Context transition is one of the most obscure topics for DAX newbies. In this article we introduce context transition, its effects, and how to leverage it r

Best practices when working with Power Query

An article on how to use parameters in Power Query

In Power Query, you can create a table that contains an aggregate value for each unique value in a column. Power Query groups each unique value, performs an aggregate calculation for each value, and pivots the column into a new table.