Power BI

Create Custom Functions in Power Query

  • Article

Introduction Often at times, you may come across situations where you need to calculate a column repeatedly multiple times in the same Power BI report or across multiple reports. Although you can use the calculated columns to some extent, these are not robust and not reusable. In order to reuse the same piece of code, […]

5 (2)

2020-04-21

5,904 reads

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

3,409 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

10,200 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

27,760 reads

Blogs

Requesting Comments on the SQLOrlando Operations Manual

By

For the past couple weeks I’ve been trying to capture a lot of ideas...

Ignoring Comments in SQL Compare

By

Recently I had a client that wanted to know how they could use SQL...

PASS SQLSaturday’s I will be speaking at

By

I will be speaking at two upcoming PASS SQLSaturday’s. These are free events that...

Read the latest Blogs

Forums

Rules in PostgreSQL

By sabyda

Comments posted to this topic are about the item Rules in PostgreSQL

Ordering with NULL

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Ordering with NULL

Catching Minor Issues

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Catching Minor Issues

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers