Group BY function HELP

[Anonymous]

Hello,

Could you please tell me if it is possible by using 'GROUP BY' to make these line to 1.

SO I want to see 1 name 1 brand (which can any of them ) and the date (which is the same) 

What I want to see one line for.

NAME= ıs the same person

I want to see one line for  DATE = '30/06/2020', not 2. 

I want to group by the BRAND. It can be any of them MAx or MIN 

Here are the attachments:

Thank you,

[Anonymous]

@Anonymous 
Maybe you can used a matrix:

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you for this solution, however I need to make something during the query, not in the visual section 

[rajulshah]

Hello @Anonymous,

You can click on Advanced and add columns that you wanted to Summarize in 'Group By' section.

Hope this helps.

[Anonymous · Accepted solution]

At the end, what i have done was :

I group BY NAME,  

and columns by ; Brand MAX and DATE MAX 

[amitchandak]

@Anonymous , refer if this can help

https://www.poweredsolutions.co/2019/07/30/grouping-rows-with-power-bi-power-query/

In the above case, you can take the max of brand and Date?