Stairway Series

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,373 reads

Stairway to Advanced T-SQL

Stairway to Advanced T-SQL Level 11: Using Logical Operators

  • Stairway Step

SQL Server supports a number of different logical operators.  These operators can be used for testing Boolean conditions that return true, false and unknown in your T-SQL code.  Logical operators are useful for defining constraints to limit the rows be processed when selecting or updating data. This chapter will provide an overview of the logical […]

4 (1)

2020-11-04 (first published: )

2,639 reads

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,319 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 14: DAX CALCULATE() Function: The Basics

  • Stairway Step

Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX CALCULATE() function, discussing its syntax, basic uses and operation. He then provides hands-on exposure to CALCULATE(), focusing largely upon its most basic uses in evaluating an expression in a context that is modified by specified filters.

5 (1)

2020-08-12

1,735 reads

Stairway to U-SQL icon

Stairway to U-SQL Level 22: Creating a Custom Extractor

  • Stairway Step

Throughout this series, we’ve consistently dealt with delimited text files; comma and tab, for instance. We’ve used the U-SQL built-in extractors to process these files. But what if we need to deal with different types of file, like JSON, XML or fixed width? That’s where custom extractors come in. U-SQL provides us with the ability […]

2020-07-01

1,194 reads

Blogs

Updated Pluralsight Course – Kubernetes Installation and Configuration Fundamentals

By

My updated course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you want...

Power BI and a Star Schema

By

I sometimes get asked from customers if they should use a star schema or...

A New Git Default Branch

By

I learned a new trick from Andrew Pruski. In a blog on avoiding PowerPoint,...

Read the latest Blogs

Forums

How to write update query to check exist column by value 1 where it exist on tab

By ahmed_elbarbary.2010

How to update check exist column by value 1 where partid exist on table...

User unable to see Logins after recreation of permissions in new instance

By johnylemony

Hello All I was tasked with setting up a new instance on the same...

Monitor SQL Server Error Logs with PowerShell

By WillemG

Comments posted to this topic are about the item Monitor SQL Server Error Logs...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Adding N/A

See possible answers