Group values

[Anonymous]

Hello, I need to group a table by an 'ID' field of 1000 different categories and apply a sum to the 'Sales' numeric field, but when I d, I apply the group by for the 'ID' field and create the sum field by the column 'Sales' I get a table with 2 columns, but I need to be able to interact with a date field, which I cannot add in the groupby, since then the grouping calculation would break down one row for each day, instead of one row for each 'ID'. I really appreciate the help!

 Hello, I need to group a table by an 'ID' field of 1000 different categories and apply a sum to the 'Sales' numeric field, but when I do, I apply the group by for the 'ID' field and create the sum field by the column 'Sales' I get a table with 2 columns, but I need to be able to interact with a date field, which I cannot add in the groupby, since then the grouping calculation would break down one row for each day, instead of one row for each 'ID'. I really appreciate the help!

[amitchandak]

@Anonymous , Why create a group by in power query? You can use ID and Sum on sales column in a visual and filter as per need based on dates

Sales measure = sum(Table[Sales])

[Anonymous]

Because I need to create an histogram with the values grouped by id (the calculation that I must pass as x-axis data to the histogram is the result of grouping the values ​​by ID). After this i should be able to change the chart date with a date slicer that I have created. 

Thanks.