Grouping of Dates Power Query - MS Forms results

[WolfgangSTR]

Good evening,

I have a question where I can not find a solution for days and I hope someone can help me.

I have results from a MSForms survey, which I evaluate with Power Query. The survey is a course evaluations.

In column B are the date and time when it was filled out. In column C are the names of the courses.

My plan was to use column B to create a separate column to separate the date to better show the date of the course (which works).

For example: I have a tennis course. 17 people give an evaluation on the day of the course. So I know that the course took place on this day.

Problem: If someone gives the course one day later, I can't assign it correctly (and it looks strange in evaluations).

My question: How can I group the one result to the other results? Is there a way to assign single results to majority results?

Thanks in advance
Wolfgang

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...