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

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.

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

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.

SUM()

Cumulative sum of previous rows

I had an update statement that took 3 minutes to run after this code change it took 6 seconds.

Sum and Count

RE: Insert on Linked Server

Read the BOL section titled "BEGIN DISTRIBUTED TRANSACTION"And also the section titled "SET REMOTE_PROC_TRANSACTIONS"

RE: Table Datatype with primary key

Oops, forget it. Reread it that you want it on both columns. Sorry.

SQLSTATE 01000 Message?

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

RE: Case in the Where clause

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 […]

RE: ASP SQL Doent work

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 […]