Adding More Columns

RANKX Ties

Counting Rows in DAX

RANKX Parameters

Using the RANKX function in Power BI

Introduction In this article, I'll explain the use of the RANKX function available in DAX. The RANKX is a sortation function which is capable of performing a quite complex sorting and ranking based on the groups and values available in the dataset. It returns the ranking of a particular number available in each row of […]

Mean Median Mode using SQL and DAX

This article explains how to calculate the important statistical functions, MEAN, MEDIAN, and MODE, in both T-SQL and DAX.

Month-over-Month calculation using DAX in Power BI

Introduction Period-over-period is an analysis technique in business that measures some value in the present and compares it to the same measurement in a comparable period of time in the past. The goal is to adjust the slice of the past you are viewing, so the same amount of time has passed in the two […]

MAX() and MAXX()

Adding a dynamic ColumnId to a DAX Calculated Table

Learn how a calculated value can be added to a table with the missing key values filled in.

Getting Prior Year’s Year-To-Date with DAX

Kasper de Jonge takes a look at how to calculate a prior year’s year-to-date over the same period as the current year: Well maybe.. what happens here is that...