Sort by column not affecting First Aggregation

[Mohamed_Retsol]

I have dates in text format specified by a FORMAT function when adding a custom column

I tried to use the First aggregation in the values field and it returned the first based on A-Z order of the column.

I noticed that if I sort this column by the date column it sorts correctly

 

but when I aggregate to First 

it once again gives the first item based on A-Z order of the column instead of Sort by column order

The custom column function is

DD MMM YY = FORMAT([CALENDAR_DATE], "DD MMM YY")

Seems like this could be a bug.

If this is intentional , could you make it a feature to choose between aggregating by sort column?

[v-haibl-msft]

@Mohamed_Retsol

According to this document, changing the aggregation to First or Last will return the First or Last string alphabetically for the given context. So even the DD MMM YY column is sorted by CALENDAR_DATE column, it will not affect the First or Last function here.

I think you can create an idea in https://ideas.powerbi.com for this feature request.

Best Regards,
Herbert