Forum Discussion
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 this process, so I'm thinking to create a dashboard in Power BI. The URL are always the same, so groups are the same
I've done some webinars but didn't found any solution to my problem. There is an automatic process for grouping this URL, before loading the data in Power BI?
I thought about creating two columns and fill them with the groups. But I don't know how to make this process automatic.
Can you help me, please?
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
3 Replies
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
