aveek22

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

5 (1)

2020-03-12

8,016 reads

Analysis Services : OLEDB Error while processing in SSAS

Problem This is one of the errors that I frequently encounter while deploying or processing SSAS OLAP cubes on the client's computers or on a remote server. Recently, one of my team members also faced the same issue and so I thought to write a resolution for the issue. The error is something like this: […]

5 (3)

2020-02-03

1,389 reads

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

3.67 (3)

2020-01-27

12,929 reads

Blogs

On Dynamic Ports, Named Instances, and Firewalls

By

Recently I had a client and their vendor trying to configure a firewall for...

Daily Coping 13 Jul 2020

By

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

Last Week Reading (2020-07-12)

By

Press Azure resource providers operations List of all of the available ADF-specific RBAC permissions....

Read the latest Blogs

Forums

Help needed in getting all AD users and groups

By Mysterio

I have very limited knowledge with server management. I need to extract AD users...

What do you like for third party database backup/restore for SQL server & Azure

By melissa.hamilton

Hi all, my company currently uses SQL server native tools to perform nightly backups. ...

Find the last occurrence of \ character and get the left of string.

By sathwik.em91

How to find the last occurrence of '\' in the following  string  and get...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers