Tag: Power Query 101
-
Parameter to filter a query
Introduction to Parameters Parameters are great helpers to obtain a full control over your queries. When used correctly, they become a time-saving and error reducing solution. This mere introduction to parameters explains how to easily pass a parameter to filter a query. Here is a little helper to encourage you practising: 1. Import a dataset…
-
Pivot, Unpivot, Transpose
Introduction to table functions Nothing is better than a table function when data needs a reshape or a rearrangement. Before going into further explanations, let me remind Power Query is NOT only treating tables, but its engine also works with lists and records. In fact, those 3 types are referred as Power Query structured values.…
BI2020.blog 