Chapter 12 CONCATENATEX()

This is a dedicated forum for people that have questions about the book Supercharge Power BI. In the event of errors in the book, the error information will be in this forum.
stillsuit
Posts: 1
Joined: Wed Nov 28, 2018 5:04 pm

Chapter 12 CONCATENATEX()

Postby stillsuit » Wed Nov 28, 2018 5:14 pm

Hi

Matt did a small cop out on page 85 :shock: :lol:

This is what I used to get the concatenated months to list in the correct order

Create a measure
Month Order = VALUES('Calendar'[MonthNumberOfYear])

Add this to the OrderBy parameter of the CONCATENATEX
Month Name Concat = CONCATENATEX(VALUES('Calendar'[MonthName]),[Month Name Values],", ",[Month Order])

John

Return to “Help with the Book "Supercharge Power BI"”

Who is online

Users browsing this forum: No registered users and 1 guest