How to use groupby and Max/Min

[naivecalf]

Hi,

I have a table, I want to groupby Category column, then find Minimum month, can anyone give some advise, thanks.

Regards

Steven

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Anonymous · Accepted solution]

Hi  @naivecalf  ,

Here are the steps you can follow：

1. Create measure.

Measure =
var _rank=
RANKX(FILTER(ALLSELECTED('Table'),[Category]=MAX([Category])),CALCULATE(MAX('Table'[Date])),,ASC,Dense)
return
IF(_rank=1,MAX('Table'[Date]),BLANK())

2. Result

You can downloaded PBIX file from here.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[naivecalf]

thank you, this is helpful to me.

[naivecalf]

please try.

Category	Date	Name
a	1/1/2020	mike
a	2/1/2020	john
a	3/1/2020	west
e	4/1/2020	bob
f	1/1/2020	mark
e	6/1/2020	bill
f	6/2/2020	charle
d	6/3/2020	niud
a	6/4/2020	mike
b	3/1/2020	john
b	4/1/2020	west
b	5/1/2020	bob
b	6/1/2020	mark
f	9/1/2020	bill
f	10/1/2020	charle
f	11/1/2020	niud
f	12/1/2020	mary
b	3/1/2020	joy
a	1/1/2020	benben

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[naivecalf]

thank you.

[Ashish_Mathur]

You are welcome.  If my reply helped, please mark it as Answer.

[Ashish_Mathur]

Hi,

In the final result, do you want only Category and MonthN columns or do you want to see all columns?  Also, so you want a Query Editor or a DAX measures solution?

[naivecalf]

Hi Ashish,

Thanks you for quick responding, I need all columns, and I want to do it by using DAX measures. 

Regards

Steven

[Ashish_Mathur]

Hi,

Share data in a form that i can paste in MS Excel.