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

1,611 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.33 (3)

2020-09-02

1,420 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

4,438 reads

Blogs

Updated Pluralsight Course – Managing the Kubernetes API Server and Pods

By

My updated course “Managing the Kubernetes API Server and Pods” in now available on Pluralsight here! If...

Daily Coping 11 May 2021

By

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

What do you do when technology changes? : T-SQL Tuesday #138

By

Our host for this month’s TSQL Tuesday is Andy Leonard (blog|twitter). He’d like us...

Read the latest Blogs

Forums

Copy value from one row to another if column matches

By bent

Hi there, I just don't get it. Need to update rows in same table....

Does lastBatch in sp_who2 really mean the time the user execute a SQL batch

By sqlfriend

I usually use sp_who2 see who is connected and is active in the SQL...

How to take a value hhmmss from the file

By Guvera

Hello, I have a file in this format "Vendor_ABC_Pro_20210422T205535". In this file, we have...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers