Forum Discussion
JP-Ronse
8 years agoHelper II
merge rows
Hi, A bookkeeping application generates an export that looks as: What I need is: Is this possible? Kind regards, JP-Ronse
- 8 years ago
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).
JP-Ronse
8 years agoHelper II
Hi Zubair_Muhammad,
Thanks for the swift reply! I am a learning newby with a long way to go (I'm afraid). Can you explain how to add a Measure?
Kind regards,
JP-Ronse
Zubair_Muhammad
8 years agoCommunity Champion
You can add it from the Modelling Tab or by right clicking the Table fields
The picture below shows this