Forum Discussion
RuiNDias
6 years agoFrequent Visitor
Automatic grouping
Hi everybody! 🙂 Monthly, I need to extract 5 000 URL from Google Analytics, group them with pivot tables in Excel (as you can see below), and present charts in PPT. I spend a lot of hours doing ...
- 6 years ago
Hi RuiNDias ,
you will have to do the transformation in Power Query. There are various options here.
Look at this..
https://radacad.com/conditional-column-in-power-bi-using-power-query-you-can-do-anything