DAX

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

9,600 reads

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

24,051 reads

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

2,279 reads

Blogs

Power BI Monthly Digest – October 2020

By

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

Daily Coping 26 Oct 2020

By

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

Welcome to 3Cloud …

By

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

Read the latest Blogs

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

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers