PowerBI

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,028 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

20,413 reads

Blogs

Better Productivity: Cycling the Windows Clipboard in Windows 10

By

A quick tip I learned, that has become handy for me. Tl;dr: Try Win+V...

Daily Coping 21 Sep 2020

By

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

Daily Coping 18 Sep 2020

By

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

Read the latest Blogs

Forums

sql server 2016 performance tuning

By rohitkocharda

I have opportunity to tune below monster query. Is there anything right off the...

How Many Distinct Records

By Sergiy

Comments posted to this topic are about the item How Many Distinct Records

Dear Past Me on My First Day as a DBA

By Pam Mooney

Comments posted to this topic are about the item Dear Past Me on My...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers