Forum Discussion

Birinder's avatar
Birinder
Icon for Helper III rankHelper III
4 years ago

How to get values from previous step in a query without adding a new query ?

Hello, here I have a table with 4 columns. In the Screenshot below, I filtered the table by Purchase as "Tv" and Method as "Cash" In the screenshot below, I grouped the ID by Purchase a...
Need Help
Birinder's avatar
Birinder
Icon for Helper III rankHelper III
4 years ago

Thank you so much for your reply. However this solution is feasible for 3-5 groups, But what If we have more than 30 group ? Writing that much larger code is still a lengthy task. 

 

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
4 years ago

Hi Birinder ,

 

As I mentioned at the end of my post, Power Query isn't really designed for this type of thing. It's ok to do it in small ways if you REALLY have to but, as you have noted, it's not efficient over many iterations.

DAX IS designed exactly for this, and as best practice should be used to do most grouping and aggregations on your original, unfiltered, ungrouped, data.

 

Pete