If you want to develop new measures with DAX, you need to be familiar with the programming language. But it’s good if you can describe your problem and have it formulated as a question. Then nothing stands in the way … Continue reading →

Inside excel you have the possibility to hide columns inside tables and pivot tables. Inside Power BI you don‘t have the possibility. If you want to achieve this behavior, there are some options. In this example I have created a … Continue reading →

If you assign tags to PPIs or tasks inside DevOps and you want to analyze them with Power BI you can use analytic views to extract this information and put them together with the tasks to create a report. Then … Continue reading →

In the last few weeks, some Colleagues asked me, why they cannot use the new suggested measure feature. They said to me, that they followed every step inside the Power BI blog posthttps://learn.microsoft.com/en-us/power-bi/transform-model/quick-measure-suggestions The reason is simple, the Power BI … Continue reading →

A customer told me, that he have a system with polls which collects numbers and strings as an answer. The result looks like these: Now, he wants to summarize the numbers and also to show the written answers. Next, I … Continue reading →

In my scenario, I get 1000 JSON files per day, which must be analyzed with Power BI. So, I will get approx. 380 million rows per year. The system has an initial load of circa. 500 Mio. rows. So, I … Continue reading →