# Counting Rows in DAX

• QotD Question

4 (1)

2020-04-10

# RANKX Parameters

• QotD Question

5 (1)

2020-04-03

# Using the RANKX function in Power BI

• Article

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 […]

5 (1)

2020-03-12

# Mean Median Mode using SQL and DAX

• Article

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

5 (6)

2020-02-28

# Month-over-Month calculation using DAX in Power BI

• Article

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 […]

3.67 (3)

2020-01-27

# MAX() and MAXX()

• QotD Question

5 (1)

2019-10-03

# Adding a dynamic ColumnId to a DAX Calculated Table

• Article

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

4.5 (2)

2019-10-01

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

• DatabaseWeekly

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...

2019-05-13

# DAX Calculations with Invalid Boolean Predicates

• DatabaseWeekly

Eugene Meidinger takes us through a DAX error: Whenever you start trying to use more complicated filters in the CALCULATE or CALCULATETABLE functions in DAX, you may start to get the following error:...

2019-04-17

# Using the DAX Calculate and Values Functions

• Article

In the first two articles in this series on creating DAX formulae, Andy Brown of Wise Owl Training showed how to create calculated columns and measures. In this third article, he turns his attention to two of the most important DAX functions (CALCULATE and VALUES), showing how and when to use them. If DAX knowledge can be compared to a heavily fortified castle, the CALCULATE function is the drawbridge giving access to it.

2019-02-18

## Blogs

### Power BI Monthly Digest – October 2020

In this month’s Power BI Digest Matt and I will again guide you through...

### Daily Coping 26 Oct 2020

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

### Welcome to 3Cloud …

A little over a month ago, Pragmatic Works Consulting was a part of a...

## Forums

### Dividing data equally in 4 sessions

By S_Kumar_S

Hi All I have a table which contains the transactions done by cards. Below...

### Unique value constraint among active records

By CanuckBuck

I have a lookup table that implements a system-generated Id for DRI purposes.  The...

### Textfield comparator.

By ben.brugman

A client would like to be able to recognize similar free-texts in a text...

Visit the forum