Data, Business Intelligence and Beyond
Max Wikström
In 2022, I wrote a popular post about how you can export your DAX measures using DAX Studio, along with other valuable Metadata from Power BI Semantic Models. This is great way to get metadata about your model and allows you to export and store it in e.g. excel format. In December 2023, Power BI … Read more
Data Analysis Expressions (DAX) is a powerful language used in Power BI to create complex calculations and data analysis. One of the key features of DAX is the ability to use variables, which can significantly enhance the efficiency and readability of your code. This article explores the benefits of using variables in DAX, provides examples, … Read more
This post is aimed towards Power BI DirectQuery semantic models. However, a lot of the information in this post is also viable for import mode semantic models. This is a short summary with the purpose of giving you an overview of some important areas that can impact the performance of your Power BI DirectQuery semantic … Read more
Welcome back to part 3 in a series of articles where you will learn how to improve and optimize the performance of your Power BI DirectQuery semantic models.In part 1 we covered the basic aspects of DirectQuery semantic models in Power BI, such as the importance of star schema modeling in Power BI and how … Read more
When working with data in Power BI, sometimes you need to find the highest (maximum) and lowest (minimum) values across several columns. This task is straightforward in programs like Excel where you can just use the MAX and MIN functions with multiple arguments like so: MAX(columnA, columnB, columnC). However, in Power BI, using DAX (Data … Read more
Have you ever wanted to search through your Power BI measures, calculated columns or calculated tables for a specific function or table/column reference? Or perhaps being able to export Power BI DAX measures for documentation purposes? If this is the case then this post is for you. As a Power BI dataset admin or author, … Read more