# RANKX Ties

• QotD Question

5 (1)

You rated this post out of 5. Change rating

2020-04-17

# Counting Rows in DAX

• QotD Question

4 (1)

You rated this post out of 5. Change rating

2020-04-10

# RANKX Parameters

• QotD Question

5 (1)

You rated this post out of 5. Change rating

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)

You rated this post out of 5. Change rating

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)

You rated this post out of 5. Change rating

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)

You rated this post out of 5. Change rating

2020-01-27

# MAX() and MAXX()

• QotD Question

5 (1)

You rated this post out of 5. Change rating

2019-10-03

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

4.5 (2)

You rated this post out of 5. Change rating

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

You rated this post out of 5. Change rating

2019-04-17

## Blogs

### Part 2: The Modern Azure Data Warehouse – ADF and ADLS

In today’s data-driven world, having the right tools to manage and process large datasets...

### A New Word: Flichtish

flichtish – adj. nervously aware how much of your self-image is based on untested...

### Automating Container Image Builds with Docker Build Cloud and Github Actions

In a previous post we went through how to use Docker Build Cloud to...

## Forums

### Realities of Predictive Analysis

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Realities of Predictive Analysis

By Brandie Tarvin

Just came across something weird. Was wondering if anyone else has ever seen this....

### Can index fragmentation cause the database to enter suspect mode?

By IT researcher

My database was in suspect mode, and when I checked using DBCC CHECKDB, it...

Visit the forum

## Question of the Day

### Creating Statistics on XML

I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do?