Using DAX to format a list of values in Power BI Desktop

Alberto Ferrari joins Patrick to walk through how you can use DAX to format a list of values within Power BI Desktop. This takes the concatenate values quick measure to the next level.

********
LET'S CONNECT!
********

***Gear***

#PowerBI #DAX #GuyInACube

[mattmiller]

This is next level. I love little details and clean up like this. Puts the polish on a report.

[abhisoulstormer]

mindblowing code and hats of to the guy who asked the question. Brilliant explanation but as Patrick said ctrl +c and ctrl+v it is! :D

[chitranawal]

Alberto you explain so well. Its a privilege to get to learn from you.

[christopherhastings]

Wow! Excelent answer to the question! I love it when SQLBI joins Guy-in-a-Cube for a great solution!

[emilyamalkin]

Wow, what a great video! Good to see my power bi heroes collaborating!

[arklur]

This is awesome, shows that what might seen impossible at first is actually doable. I love DAX.

[AdiCristea]

I'm going to a session with this man tomorrow, can't wait to get DAXified! Thank you, Patrick, for bringing in Alberto.

[gonzalorengifo]

That is so incredible, master Alberto Ferrari, thanks Guy in a Cube for your great work!

[mehdihammadi]

Just wonderful and with the explanation the measure becomes so fluent. Thank you very much for sharing.

[edgards]

Alberto & Marco are the DAX gods!!!

[feo]

Alberto is the best! Even with the Italiano accent, I understand him the easiest.

[rosswaterston]

Always great to see and hear from Alberto, that is such a great piece of DAX, really understood it this time around!

[yyymmmddd]

Great stuff! Simply great stuff! Opens so many opportunities to utilize technique displayed in many other areas.

[stephenbrincat]

Wow well done guys, excellent explanation from Alberto.

[madiakns]

Hi Alberto & Patrick, This is a great what if we have two filters.... Quarter & Month?

[sumeghamehta]

Hi Pattrick,
I am having a date calendar being built using dax wherein the financial year is basically 4-4-5 or as we say 13month period.
The calendar is working absolutely fine. However, just as an exception in one period of the year instead of 5 weeks its actually 6 weeks, how i can incorporate thar change in my dax, only for one specific period.

[Jordan-gbby]

Hey excellent ! Thank you for your sharing !
But I have a question, what is the fourth parameter :'Date'[Month Number] of the function Concatenatex() ? Why do we use it ?
Thank you again,

[pratikfutane]

Thanks a lot for bringing this Up!! Its a next Level!!

Really clever way to resolve the problem!

[brianxyz]

Great video! Please do more videos on DAX and M.