Forum Discussion
merge rows
Conceptually, queries shape unstructured data into tables. Next, DAX (and visuals) may kick in for further data analysis, like aggregation and (filter) context sensitive calculations.
So, in this specific case, I would recommend a Power Query solution, even though it can also be done with DAX (in combination with visuals).
Luckily you still have the recommended Power Query solution. :manwink:
Dag Marcel,
Can you recommend some reading to get more familiar with PQ?
Prettig eindejaarsfeest.
JP-Ronse
Dankjewel, insgelijks. (Thanks, likewise)
With regard to readings: sometimes I publish video's about specific Power Query subjects on my YouTube channel and I recently published a Power Query (M) Functions dashboard.
Otherwise you can find learning resources on http://www.thebiccountant.com/learning-resources/
Thanks.