Calculating MODE in DAX is a key statistical task when working with data in Power BI or other platforms that employ Data Analysis Expressions (DAX). Given that DAX lacks a native MODE function, it’s necessary to devise our own method for determining the most frequently occurring value in a dataset. This blog post will delve …
Have you ever faced the challenge of managing hundreds of Power BI reports and found yourself unsure about the data sources they connect to? I offer a straightforward solution which is tested in the real world – extracting data from Power BI reports with Python and Power Automate. Essentially, we are going to build a …
The power of data analysis lies in the ability to manipulate and transform data to suit your business requirements. The Data Analysis Expressions (DAX) language plays a pivotal role in helping you achieve this within Power BI. In this blog post, I will dive into a practical example, demonstrating how to create a SLAStandard column …
Often when I’m preparing a dataset in Power BI just importing tables from sources does not suffice. Because of the intricate requests from the business side – I continuously need to use data manipulation with SQL. In this blog post, I will share how to make the best of an annoying situation with SQL. Some …