Power BI

Stairway to DAX and Power BI - Level 16: The DAX ALLEXCEPT() Function

  • Stairway Step

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX ALLEXCEPT() function, discussing its syntax, uses and operation. He then provides hands-on exposure to ALLEXCEPT(), focusing largely upon its most popular use in removing filters from all columns in a table - except the filters we specify.

2020-10-14

863 reads

Power BI Histogram Example using DAX

  • Article

Companies use a Bell Curve approach to measure performance. As part of this approach they create a histogram. A histogram is a statistical concept and according to Wikipedia it is defined as a graphical distribution of the numerical data. A histogram is made of several bins and bins can be considered a range of values or a benchmark

2020-09-16

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 15: The DAX ALLSELECTED() Function

  • Stairway Step

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX ALLSELECTED() function, discussing its syntax, uses and operation. He then provides hands-on exposure to ALLSELECTED(), focusing largely upon its most popular use in supporting “visual totals” in Power BI.

4 (2)

2020-09-02

1,169 reads

How to override Date Filters in Power BI

  • Article

Problem A few weeks back, I got a request from a client of mine who had a very special requirement. They wanted to display values for a specific period in the past based on the selected dates in the Power BI report. Let us assume that if we select 30 June 2020, the report has to […]

2020-08-17

2,112 reads

Business Reasons For Implementing Power BI

  • Article

Data is stored in heterogenous environments in many organizations. Enterprise reporting for management and other departments is created using a variety of tools.  There are Excel Workbooks, SSRS Reports, Tableau Dashboards, flat files, data streams from MySQL databases, etc.  Each data extract or report is created by a BI or DB Development Team member.  Often […]

2.83 (6)

2020-07-07

6,441 reads

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

4,867 reads

Blogs

One Thousand SQL Saturdays (*ish)

By

This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...

Top Azure Synapse Analytics and Power BI questions

By

I have listed below the top questions I see from customers about Azure Synapse...

Pre-Conference Workshop and Sessions at PASS Summit

By

I’m pleased to announce that I will be presenting at PASS Summit. This year...

Read the latest Blogs

Forums

Does T-SQL have a way of truncating real and float values?

By Rod at work

I'm working on a new app and database, which has real data types in...

SQL Server datetime. Is there a way to determine the time zone?

By dndaughtery

I have an error Im looking into and I noticed that a datetime is...

SSIS Catalog - Dropped the database & recreated the catalog - can't deploy

By sgmunson

All, I have a DEV server where the SSISDB database ended up in emergency...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers