sum

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 13: Simple Context Manipulation: Introducing the DAX All() Function

  • Stairway Step

Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX All() function, discussing its syntax, basic uses and operation. He then provides hands-on exposure to All(), focusing largely upon its most basic uses in manipulating filter context.

5 (1)

2022-11-23 (first published: )

4,827 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 11: Function / Iterator Function Pairs: The DAX Concatenate() and ConcatenateX() Functions

  • Stairway Step

Continuing his examination of the evolving DAX “Function / Iterator Pairs,” Business Intelligence Architect, Analysis Services Maestro, Microsoft Data Platform MVP and author Bill Pearson introduces the DAX Concatenate() and ConcatenateX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to Concatenate() and ConcatenateX(), in joining two text strings into a single text string, and in returning the concatenation of an expression evaluated for each row in a table, respectively.

2022-11-23 (first published: )

5,235 reads

Technical Article

RE: Case in the Where clause

  • Reply

Thanks for reply,All-includes all Clients and 999 is just another client and should be treated a bit differently LATER.999 is just a Client Number and it could be thousands of clients. So I guess, I am sorry I didn't expain it well, the question is how to distinguish between ALL (which is not a Client […]

2004-03-30

Technical Article

RE: ASP SQL Doent work

  • Reply

I gave you a little extra context, Line 151 is where the error is at which there is nothing there, the code actually starts at Line 152.  http://www.macrotransport.com/availableload.asp that is the error I am talking about, one out of the two I have, everything was fine untill the upgrade, seems like an MDAC thing, it's all new […]

2004-01-30

1 reads

Blogs

Hyperconverged storage tuning tip for SQL Server

By

We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...

Daily Coping 25 Nov 2022

By

Today’s coping tip is to connect with someone from a different generation. This tip...

Snowflake Classic UI vs Snowsight

By

This blog post is not about which User Interface is better, Classic or Snowsight...

Read the latest Blogs

Forums

Restore takes forever

By Edvard Korsbæk

Hi all! I have som pretty smal databases - the backup is app. 250...

DML Trigger Limits

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DML Trigger Limits

A week in Seattle in 8 Slides at the PASS Data community Summit 2022

By Tonie Huizer

Comments posted to this topic are about the item A week in Seattle in...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers