Power BI

Learn how to calculate 50 and 100-day moving average with DAX for your Excel cryptocurrency dashboard. With video and Learn and Earn activity

This week, I got an interesting question about Power BI: “Can I format a specific cell or row in a table or matrix?” My answer was yes and I thought it could be a great blog. Let’s say, you need to format the Sales Amount for all countries as a whole number, except for Australia. ... Read morePower BI: How to format a specific cell or row in a table or matrix?

Now that you can create icons in Power BI, a common question is "where can I get a list of icon names?". This article provides a list of all standard icons.

There are two functions in DAX that return the list of values of a column: VALUES and DISTINCT. This article describes the difference between the two, expla

The DAX functions CONVERT and REMOVEFILTERS were introduced in August 2019. This blog post shows what they do.

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