Adding date slicers to a table that has aggregate columns and a group by column

[akhaliq7]

I have two aggregated columns and one column whereby I am using a group by is it possible to use a date slicer on this table and what steps would I need to take I don't have a date column in my group by table I don't think I can add a date column but I can add a min(date) and max(date) but just unsure how I would go about using a slicer on this table.

p.s. the group by column is a sales persons name field and not a date field if i change that to a date field then my group by will not return what I want it to return what i want is as there is a count(id) column I want the count to change based on the date field in the higher granular data 

[amitchandak · Accepted solution]

@akhaliq7 , Create a month start date or qtr start date in power query, and group data by that date

Date.StartOfMonth and Date.EndOfMonth: https://www.youtube.com/watch?v=qtUNYly0K2w&feature=youtu.be