dax

It is easy to get Power BI to show only compeleted months of data. Read my article explaining a dynamic DAX formula that filters out part completed months.

This article describes how to create a slicer showing the values of multiple columns, applying the filter on any of the underlying columns. Power BI provide

If you have been watching Power BI news recently, you know that Power BI fields now support custom formatting. In this short blog article, I am going to explain how to use this feature to achieve your custom formatting. You can do things like showing () for negative values, showing custom date/time formats, and etc.…

Now that we can apply custom format strings to fields and measures in Power BI in the September 2019 release, I thought it would be useful to provide some examples of what’s possible with this very…

You might have wondered that there is no DAX Quarter function in Power BI. Here in this short blog post, I explain some easy methods for calculating quarter. If you like to learn more about Power BI, read Power BI book from Rookie to Rock Star. Sample Data To start this example, you can open…

This article describes how to compute previous year values up to a certain date. This is useful in case the data is presenting incomplete months or years. I

This is What I Want (What I Really Really Want): Zeroes to Rank Poorly. Divide by Zero Errors to Display “N/A.” And “N/A” to NOT participate in my ranking. RANKX: the Mother of Many Blog Posts Ya know, we could probably write articles about RANKX for an entire year. There are just SO many subtleties to it, and

This blog post shows how you can accurately replicate the Excel TRIMMEAN function in DAX, accounting for duplicate values at tails.

Patrick walks you through how to use custom format strings in Power BI Desktop. From dates and time to numbers, he calls out some things to look out for. Custom Format String Documentation: https://do…

Learn how to use DAX to create a custom TEXT column sort order. This tutorial explains a simple solution to ordering items. Click here to learn more.

REMOVEFILTERS() is a new DAX function that was created to make the language easier to learn and understand. Learn why REMOVEFILTERS() was introduced here.

I was doing some work recently which required DAX calculations to convert values from a specific base to another, e.g. to convert a value in hexadecimal format to a base 10 representation (or decim…

As an extension to my recent article on base conversions in DAX, I thought I’d show how these conversion calculations can be used to help you perform bitwise calculations in DAX. At present, …

There are some functions in DAX that are useful in very specific scenarios. For example, sometimes, you might want to create a table entirely in DAX. If you want to do that, what are your ways and how it is possible? This might be helpful especially in the first days of learning about DAX. Let's…

In another blog article, I explained how easy is to use table constructor in DAX to create a data table fast in Power BI. However, that method has some limitations, such as not being able to name columns or set their data types. In this blog post, I'll explain about DataTable function in DAX which…

For this blog, I want to share an interesting data modelling technique which you might consider when having performance problems with time intelligence calculations. This particular pattern works w…

Reporting/Analytics Made easy with FourMoo and Power BI

Power BI lets you filter the visual data by a measure, such as by a measure that dynamically calculates the customer’s rank. This is convenient but there are performance implications related to the wa…

If you ever need to create a list of numbers (either decimal or whole number), or list of dates and times, there is a very simple and useful function in DAX which helps. GenerateSeries is a simple fun…

In Power Query, there is an easy way to use Duration and get the number of days, hours, minutes and seconds from it. However, sometimes you need this calculation to be dynamic as a measure in DAX. I h…

This article shows how to add an additional “other” row to the selection obtained using the Top N filter in a Power BI report. Power BI offers the abili

This article describes how to analyze the performance of a DAX measure based on a DISTINCTCOUNT calculation and how to evaluate possible optimizations. The

This article provides information to help choose between DAX and Power Query when a table needs to compute additional columns. When building a data model in

Patrick shows you how to be efficient in Power BI Desktop using keyboard shortcuts for the DAX Editor. It is crazy bananas! Documentation: https://docs.microsoft.com/power-bi/desktop-accessibility

In this blog, you will learn how to detect abnormal behavioral patterns, outliers, and anomalies in your Power BI data sets.

I wasn’t originally planning on including an article on Incremental Aggs as part of this series, but I like the idea, and it seems like a good fit for the series, so here goes. The series so …

This post is the last in this series (for now) and describes a technique used to enhance performance in Power BI models that use Aggregate Awareness. I hope you’ve enjoyed the series as much …

My last article described the Shadow Model data modelling technique and how you can use it to help resolve a specific performance challenge caused by tables forced to direct query mode in particula…

This article shows a basic technique used to sort months according to a fiscal calendar, by using a couple of calculated columns and the “sort by column