Hi @PowerAddict and other experts,
I have done a collection using the following formula and it looks ok
Following is how it looks like, the Root comes as a group with ID and Value.
Following are my requirements,
1. How can I get the Customer Name root..... with value only to my current collection
2. How can I create a collection to show the Total Invoice Value by Location (total must be summarized by location)
Solved! Go to Solution.
Thank you @PowerAddict your direction is helping me lot.
I was able to find an answer to the 2nd question by my own, i applied the following and it worked
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.