Forum Discussion
Grouping data (rolling up)
Ya, power query can help you out. Here is a good starting place: https://www.powerquery.training/portfolio/group-summarize-data/
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"
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
