I would like help i have a gallery and all customers in one gallery is there a way to group those customer in to one like example, when i add the order to those customers it group only one line in the gallery if its same customer.
example gallery has,
i would to make it John to show only one line and when i click then i can make another form for details order date etc.
Please help thanks
the approach would be the same. you want to bind your gallery to a table that has the distinct names of your customers. on the items of your gallery use Distinct(YourList, CustomerNameColumn)
Hi @Ramole ，
Do you want to make the same customer in one item and display the sum order number of every item?
If so, I suggest you use GroupBy function.
Set the gallery's Items:
Then, display the customername and sumorder field in the gallery.
Using CountRows(details) function could return how many rows sharing the same customer name of each item.
i dont know if i am doing wrong but not working for me here is what my code look like
AddColumns(GroupBy(shipmentsdata,"Company.Value","details ??"),"shippingfee",CountRows(details ??))
please see what i am doing wrong
Thanks for your support
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand