Today, I am going to talk about large Power BI data models. A lot of times I explain my people about the scalability of the in-memory DAX engine that is responsible for holding and compressing the data in a Power BI model, I get the question what is the limit. What is like a maximum … Continue reading A Large Model in Power BI →

For BI reporting the financial general ledger in (i.e.) Dynamics NAV you have the G_L Entry table as a fact table and GL Account which is a dimension table linked. No problem with this. However ... there is always a however... However, there are the so called totalling accounts, which as the name suggests are … Continue reading Totaling Financial Accounts in Power BI →

Sometimes in Customer Analysis we need to calculate the projected customer number. And the projected customer churn. In the demo dataset we have the given number of new customers and the retention factor for every year that customers stay with the company (by buying items, renewing subscriptions, etc.). The retention factor is the percent of … Continue reading Customer Retention / Churn Analysis →

I recently came across a similar pattern, transforming a selection of numbers into a text of numbers sequences. I found the pattern intriguing, partly because I had been solving a similar patterns in SQL working as a data warehouse engineer. And there I knew a 'special trick' or optimization technique to solve this kind of … Continue reading Slicer Selection To Sequence(-s) →