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).
Hi Zubair_Muhammad,
I am using excel 2013 with the Power Query add-in and I don't find this option. I tried with a custom column but it doen't accept the formula. Maybe it is just not possible with my configuration.
Kind regards,
JP-Ronse
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.