Stairway to DAX and Power BI

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.

Free eBook: SQL Server Execution Plans, Third Edition

If a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how the data was retrieved, and from which tables and indexes, what types of joins were used, at what point filtering, sorting and aggregation occurred, and a whole lot more. These details will often highlight the likely source of any problem.

SQL in the City Summits Down Under

Redgate are inviting senior data professionals to attend one of the upcoming SQL in the City Summit events taking place in June. If you’re interested in learning how your business can benefit from implementing Compliant Database DevOps this event is for you. Find out who’s presenting and register for a Summit near you today.

Blogs

SQL Server Containers Are Boring

By

Not really, but sort of. The beauty of containers, at least in a dev/test...

Public Role Permissions – Back to Basics

By

If you are being serious in your role, then the amount of times you...

It’s interesting how an OR short circuits.

By

I recently did a post on the case expression short circuting and received a...

Read the latest Blogs

Forums

Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

Mail when value of field < or > paramater%

By Brussel

Hello, I have a question and I  don't know if it's possible to configure...

NEED HELP WITH SUM TABLIX AMOUNT AND SUBREPORTS AMOUNT

By Ysa

I need to add the subtotal between the tablix and subreport,  I need to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers