Dynamic lists

So far, you have been able to read several “recipes” on this blog which were about Data Validation and lists. Office365 (Microsoft365) subscription users have access to dynamic array functions that easily handle variable-length lists. But what should users with an older version of Excel do? In the text that follows, you will learn how to solve this problem with the help of the named ranges, OFFSET and COUNTA functions.

Power BI groups

Power BI groups enable grouping of data within visuals for more efficient reporting. Depending on the type of dimension present in the visual (category or measure), it is possible to group parts of the report by default categories (Lists) or reporting segments (Bins). It is also possible to create groups of data and as well view a group which contains other series (Others). You will find out more about this in the following „recipe“ …