Combine delay reasons into one line

[HishamAT]

I have a table containing flight number and delay reason 1, delay reason 2 and delay reason 3 how can I make the delays in one line with a new line after each delay reason using Dax

Flight Num	Delay 1	Delay 2	Delay 3
12	LateX	LateY	LateZ
13	LateA	LateB	LateC

To Be in the presentation of power bi

Flight Num	Delays
12	LateX LateY LateZ
13	LateA LateB LateC

[Ashish_Mathur]

Hi,

PBI file attached.

Hope this helps.

[Ritaf1983 · Accepted solution]

Hi @HishamAT 
If the visual on your image is your final goal you can create a measure like :

Delays = MAX('Table (2)'[Delay 1]) &UNICHAR(10) &MAX('Table (2)'[Delay 2]) &UNICHAR(10)&MAX('Table (2)'[Delay 3]) &UNICHAR(10)

If not you will need these reasons as some categories than rather you should unpivot your table from PQ:

and after closing and applying create the hierarchies matrix:

more information about unpivot is here :
https://www.youtube.com/watch?v=tAIqopmj9RA
The pbix  with both solutions is attached 

If my answer was helpful please give me a Kudos and accept as a Solution.