Power BI

Power Query or SQL Server? Which, when and why

  • Article

When it comes to developing a Power BI report, we can use it for accessing data, transforming the data, and turning the data into information using visuals. With no doubt Power BI can do the job from beginning to end. Now, this is not the only, nor necessarily the best, tool for all the steps […]

4 (3)

2021-01-25

6,639 reads

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

2,145 reads

Blogs

Daily Coping 21 Sep 2021

By

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

#PowershellBasics: Bulk insert.

By

In my last post I talked about invoke-sqlcmd. It’s a nice easy way to...

Lambda Architecture in data systems and possible meaning of this name

By

(2021-Sep-21) There is one scene in "The Core" movie that I really like when two geophysicists...

Read the latest Blogs

Forums

PostgreSQL Date And Time Part 2

By Shivayan Mukherjee

Comments posted to this topic are about the item PostgreSQL Date And Time Part...

To Inifinity and Beyond With 1=1

By Steve Jones - SSC Editor

Comments posted to this topic are about the item To Inifinity and Beyond With...

Unloading an Extended Stored Procedure

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Unloading an Extended Stored Procedure

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers