DAX

If you’ve worked with calculation groups, you know how powerful they are for simplifying measure logic and enhancing report functionality. It doesn’t stop there though; selection expressions offer even more fine-tuned control.

When using time intelligence functions, the automatic REMOVEFILTERS on Date can make maintaining filters on the Date table challenging. This article shows a

I am always looking for optimizations to facilitate real-world use cases. In this article, we had a requirement to create every possible variation of our time intelligence calculation group for every base measure in a Power BI semantic model. Why explicit measures? Calculation groups are awesome. However, they lack some customizability in ordering, etc. and ... Read more

This article describes how to implement a dynamic Pareto calculation in Power BI based on a measure that can be selected from a slicer and dynamically filte

I usually do not write about announcements and new features until we have had time to try and test them in the real world. However, there are always excepti

Visual calculations are useful for performing calculations specific to a visual. Conditional formatting is a great example of this concept. In this article,

IntroductionOverview of the NotebookWhy Use This Notebook?Getting StartedConclusion Introduction Part of the role of the Azure Data Insights & Analytics team is to test new features and provide…

This article shows how you can change the calculation of all measures in a specific folder with the INFO.VIEW function and Calculation Groups in DAX

This article describes an Accounts Receivable Aging report in Power BI, and shows how to simplify a business problem using existing modeling patterns. The A

This article describes the differences between the ALL and CROSSFILTERED functions in DAX. Have you ever wondered what the subtle difference between ALL and

Learn how to leverage VertiPaq Analyzer tool to get a quick and convenient insight into your Power BI data model structure!

The Mastering DAX Workshop is the most advanced course available on the DAX query language, bringing our students to a whole new level of expertise.

The new version of the Power BI Cleaner tool prevents you from deleting DAX expressions that have been used in calculation groups.

As I’m sure you’ve guessed by now I’m a big fan of dynamic M parameters in Power BI. They’re easy to use in Power BI Desktop but what if you want to use them in your own DAX…

The next chapter in this series on Creative Aggs looks at Filtered Aggs, what they are, and how you might use them to speed up reports connected to Power BI and SSAS models. The series so far : Int…

Patrick shows you how you can clear the Power BI Desktop model cache when troubleshooting DAX performance.

Patrick looks at how you can use DAX Studio, or SQL Profiler, to do query profiling on Power BI Premium. This can help you debug query performance and more.

Export data from visuals in Power BI has limitations that can be circumvented by a simple trick. Using DAX Studio with a automatically created query:

Time and time again when I begin talking with Excel users and ask to see what current reports they are using, they usually show me [...]

Did you know, in some cases, it is possible to add columns to your model to speed up the DAX used behind visuals to make them as much as 100 times faster? The PBIX helper file for this article can …

Patrick walks you through how you can use Power BI to build a custom KPI scorecard. The key is the UNICHAR DAX function. Demo files: https://guyinacu.be/demofiles

Way back in Oct-2016, Microsoft released a feature in Power BI Desktop that makes the process of creating groups much easier for the average user. I was reminded of this feature by an article by Re…

Thanks for watching this week’s Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup134 2 Minute Tuesday: https://guyinacu.be/databrickserror Patrick’s tech video: https://guyinacu.be/modelview Adam’s tech video: https://guyinacu.be/powerbigetdata Sources DAX 101: Summing values for the total (@FerrariAlberto) Power Query Memory Usage, Dataflow Container Size And Refresh Performance (@cwebb_bi) Creating a Fiscal Saturday Calendar (@kpuls) Governance settings for Power […]

This post explains how to use Power BI DAX measures in an efficient way, when there are multiple disconnected slicers that you want to use.

In this blog post, I am showing how to export all data from a Power BI file to CSV files or SQL Server tables.

I see a lot of Power BI users asking for the ability to set a default slicer selection in their reports. Although this isn’t natively supported as of yet, we can imitate this functionality with a little bit of DAX! A general overview of the process to accomplish this task is as follows: Create a slicer. Create a

Welcome to post number 6 in my series concerning Microsoft Exam 70-778. The series aims to provide a revision tool for those who are looking at taking the exam and to also provide an introduction i…

Fun with DAX – A-Maze-ing DAX (@PhilSeamark) 24 Days of PowerPlatform – Day 1 – Let’s kick it off.. (@wstrasser) Power BI Fast and Furious with Aggregations (@Rad_Reza) Power BI Dataflows and Slow Dat…

Makeover Monday this week focused on a variation of the “Big Mac Index”, where costs for various activities are compared in different cities. The original article presented data in a st…

In this article, we will see how to combine different dimensions and facts inside a single matrix table visual.This approach helps us create fewer measures and tables, but at the same time, it provides us with greater design possibilities, like conditional formatting across the whole column even though there are different measures invoked inside the column. The previous would be impossible without this technique....