Forum Discussion
Grouping data (rolling up)
Hi, I am working on a very large dataset and I am making a report using Power BI. It takes a very, very long time to edit queries, load data etc and is a strain on the PC when all of this is happ...
Thanks for the suggestion. This solution accomplishes exactly what I'm looking for, but if I understand the process correctly, Power Query can only accomplish this within Excel?
The file I'm working with is very large and I will not be able to open it in Excel. Is there a way to accomplish what I want without having to import the data into Excel?
Thank you,
Greg
Sorry. I reall meant "the piece of Power BI that would be called Power Query if we were still in 2015" :) The functionality of Power Query is also in Power BI under "Edit Queries"