Forum Discussion
Solved
How to pivot and display multiple values
Hello, I can't solve a problem that seems too easy. If someone could help me. We have a program that gives us this type of list: We need to put it this way, but I can't find a way to tr...
Hi Anonymous ,
I am always up for improved solutions, but in this case I'm wondering why.
My pivot solution isn't only faster to implement but will also run faster when executed. Or am I missing something here?:
Does this have to be in Power Query. The original format is very good for storage and further analysis.
If you keep it this way, create a matrix with Hour and Day then write a measure like:
MeasureW = CONCATENATEX(theTable, theTable[Name], ",")it should work