Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.