DAX

This blog post shows how to find out which columns are being used the most in visuals and DAX measures in Power BI Premium/PPU

If you aren’t using Tabular Editor to format all of your DAX code for you, you are missing out. I’ve written a super short script that will format all of your DAX code in measures, and make it look picture perfect in Power BI Desktop. First, you need to download Tabular Editor. The free version is

A handy feature of Tabular Editor is the ability to create C# scripts to simplify & automate basic development tasks. One such task that can be easily automated is the formatting of DAX code in the data model . Particularly upon inheriting a data model from someone else, formatting the DA

Video by: Reid Havens Learn how to apply some [DAX] wizardry to intelligently format string values when concatenating KPI values together. RELATED CONTENT 🔗 Kane Snyder's Calculation Group Presentation Jeff Weir's Twitter Post

Charting time magnitudes and displaying hours and minutes in the data label is not straight forward in Power BI, but can be achieved with a Calculation group

The Data Type in a DAX Column is explained in this detailed article from Greg Baldini. This can be observed when using Dynamic Ranking.

Get the list of default icon names in Power BI for conditional formatting and learn how to use it in a DAX expression

List of the most common univariate statistics DAX functions available in Power BI, as of now most of them are built-in functions but the more complex ones still require writing some Dax code. The list will be kept up to date please let me know if you thing a function is missing. eyJrIjoiNzFjZDkwNTkt...

Part two in this series on Power BI Aggregation tables focuses on Power BI data models with more than one aggregation table. The first article introduced Power BI Aggregations and included a walk through configuring a Power BI model with a single aggregation table. Intro to Power BI Aggregations Multiple aggregations tables DUAL storage mode … Continue reading Power BI Multiple Aggregations tables

There are some cases that we want to add a leading zero to a digit, such as showing 01 instead of 1, 02 instead of 2 and so on. We have two options to do this in Power BI, doing it in Power Query or doing it with DAX. Adding a Leading Zero in Power … Continue reading Quick Tips: Adding Leading Zero to Integer Values (Padding) with DAX and Power Query

Find out which visuals in your Power BI report generated a given DAX query

This article introduces the Power BI User-defined Aggregations feature. It includes a walkthrough example (with video) showing how to configure and test a simple model to use this feature. If you have not used Power BI User-defined Aggregations before, need a refresher or reminder, or are just keen to understand how to configure, this article … Continue reading Intro to Power BI Aggregations

Here you will find blogs related to Power BI, DAX, Power Query, VBA, Excel and much more. Power BI | Antmanbi.com

The popularity of Power BI has increased dramatically in the past few years. I am seeing an increasing number of enterprise customers who built complex composite models combining import tables with DirectQuery tables. Many users have asked questions on how DAX queries and measures are tran

Shared via Flipboard

This story is intended to share small bits of code that I have found extremely useful in my day to day activities as a Power BI consultant.

This is the third article where I have covered building a P&L in Power BI. My first 2 articles here and here focused on how to use the DAX language to solve some of the common problems with P&L reporting, such as adding sub totals into the visual, % of [...]Read More »

learn how to document your entire Power BI file in a few clicks, including all measures, codes, visualization, all for free and simple to do.

We all write our codes in a proper format so that readability and understanding of codes become easy. While working with POWER BI, we use DAX Expressions to write our measures and calculated columns. We know that formatting is not required in DAX. It’s normal to see DAX expressions that span over 10...

This article introduces the two basic visual context navigation functions: EXPAND and COLLAPSE. In a previous article, we introduced VISUAL SHAPE, the table

In the realm of visual calculations, understanding the functionalities of EXPAND and COLLAPSE operations is crucial for manipulating visual contexts, especially within hierarchical structures. These functions, newly introduced in Visual Calculations, play significant roles in navigating hierarchical structures in Power BI visuals, offering users a dynamic way to interact with their data and gain clearer insights.

With the introduction of visual calculation in the February 2024 release of Power BI desktop ( – this gives us some new possibilities to add calculations on the individual visual and some new…

This article describes the different approaches to format your DAX measures in Power BI semantic models using format custom and dynamic format strings. Form

This article introduces the VISUAL SHAPE clause, which defines a hierarchical structure for a table used in visual calculations. Visual calculations, introd

Visual calculations are a new feature in DAX that aims to simplify the use of DAX for users by introducing calculations at the visual level rather than at t

The DAX windowing functions have helped me a lot in tackling complex analytical challenges. Nevertheless, I do not use them daily. This means sometimes I need time to regain the “windowing feel” again. This article will shorten the time until I’m thinking “windowing” again. Maybe it might help you as well.

When you apply row-level security to a semantic model, there are limitations in using the USERELATIONSHIP function. This article shows the issues, provides