Power BI

Fetch Web Data in Power BI

  • Article

Introduction Reporting on web data has been a fascinating part of developing any dashboard or reports in Power BI. Often this data is available either free that can be consumed anonymously or by using some kind of authentication mechanism. In this article, I'm going to demonstrate how to connect to a web application from Power […]

2020-03-17

2,191 reads

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

6,743 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

3,839 reads

Blogs

Daily Coping 30 Mar 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Error handling protip: @@Error resets after the next command

By

The system variable @@ERROR is a quick and easy way to retrieve the error...

Azure Analysis Services – Processing Hot & Cold Data using Tabular model partitions

By

Introduction Recently have been working on a “Proof of Concept” task where I wanted...

Read the latest Blogs

Forums

The Coping Thread

By Steve Jones - SSC Editor

I've started a series on my blog about coping strategies during the pandemic: https://voiceofthedba.com/tag/life/...

Get the difference from one record to the one previous

By Meridian9300

In it's simplest form I want a table that I can use to store...

Regarding for Microsoft Azure Certification

By Ankitdixit

Hello Everyone, I am new here and I am preparing for microsoft azure certification...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers