BI Blog

Welcome to the english part of my Blog on!


This blog is aimed at employees of specialist departments who analyze data in their daily business with Microsoft products such as Excel or Power BI and are constantly looking for new solutions and opportunities to improve.
It is also aimed at anyone who has discovered his passion for data analysis with Power BI, Excel Power Add-ins and related technologies such as SSAS Tabular or third-party tools.
This blog is meant to be a casual place where we can exchange ideas and learn from each other.


I hope you'll have lot of fun with my blog!  

Start of series: Getting started with R in Power BI

Power BI is a versatile Business Intelligence platform that offers an endless range of options, features and technical skills to master. In addition Power BI can be enhanced by various extensions such as Python or R. These languages open a wide range of capabilities to use in your data analysis process. This series is about using the R-language in Power BI.



Best practice: Where to create a calculated column in Power BI, SSAS or Power Pivot?

One of the many aspects I love about Power BI is that you can achieve the same goal in many different ways. This will allow you to choose the path that best suits your personal preferences, technical skills or specific restrictions...



Programming "For-Next"- loops using List.Accumulate()

In the last part of the series about programming loops in M, I want to show you a way to create the "For-Next"-loop type in Power Query. For this we take a closer look at the function List.Accumulate()…



Programming "Do-Loop" loops in M using List.Generate()

In the second part of the series on programming loops in M, I want to show you an alternative way to create loops in Power Query while overcoming the performance drawbacks of traditional recursive functions. The function List.Generate()...



Programming recursive functions in M

The M-Language is a functional language that is foreign to the classical loop constructions of other languages. As a basic element for repetition of expressions, functional programming languages use recursion instead, and the M-Language also offers you this functionality. In addition, M has other functions with which you can simulate loop-like behavior. In this three-part series I will show you how this works…