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
Hi GCGradwell,
Take a look at the blog below:
Deep Dive into Query Parameters and Power BI Templates
Using Query Parameter to filter rows based on special column should meet your requirements.
Addition reference:
Power BI Desktop Query Parameters, Part 1
If any further help needed, please feel free to post back.
Regards,
Charlie Liao