why Power Bi not sort the x Axis Values? get max value of each YearMonth

[jamiguel77]

hi all i have a column date/time i try transform(add a column) for get Year/Month column, but cant, in my excel column i try: added a column with this formula:

=TEXTO([@[Date & Time]],"aaaaMM")

LOTE 12 DATOS.xlsx
	A	B	C	D
1	Date & Time	MonthYear	Inside Temp - ∞C	High Inside Temp - ∞C
2	30/06/2020 00:00	202006	25.8	26.1
3	30/06/2020 00:15	202006	25.7	25.8
4	30/06/2020 00:30	202006	25.4	25.7
5	30/06/2020 00:45	202006	25.4	25.6
6	30/06/2020 01:00	202006	25.2	25.4
7	30/06/2020 01:15	202006	25.1	25.3
8	30/06/2020 01:30	202006	25	25.2
9	30/06/2020 01:45	202006	24.9	25.2
10	30/06/2020 02:00	202006	24.9	25.1
11	30/06/2020 02:15	202006	24.8	24.9
12	30/06/2020 02:30	202006	24.6	24.8
13	30/06/2020 02:45	202006	24.4	24.6
14	30/06/2020 03:00	202006	24.2	24.5
15	30/06/2020 03:15	202006	24.2	24.3
16	30/06/2020 03:30	202006	24	24.2
17	30/06/2020 03:45	202006	24	24.1
18	30/06/2020 04:00	202006	23.8	24
Original

Cell Formulas
Range	Formula
B2:B18	B2	=TEXT([@[Date & Time]],"aaaaMM")

in power bi, not show sorted:

see 202006 this column would be the first... how to fix?

other question, how to get the max value of each YearMonth column?




Thanks

 

[jamiguel77]

More Info:

i tried:

if you see no syntax Error....
when add the column say me this error:

Any ADvice?

Thanks

 

[RoryA]

Your column is DateTime not Date, so you need DateTime.ToText

 

[jamiguel77]

ok, worked: DateTime.ToText

why continue not sorting..? the columns?

thanks

and how to specify the Maximum Value

of this column:

thanks

 

[jamiguel77]

Man need separate n other thread other questions?

Thanks

 

[jamiguel77]

Solved the ordering, now how to change sum by max?
the default is sum.
thanks

 

[RoryA]

If you select it in the Field list, then on the Column Tools tab of the Ribbon you can change the summarization type to Average, or you could create a new measure for the average.

 

[jamiguel77]

@RoryA thanks man, solved with creating a new measure.
i tried:

but not worked....

Thanks

 

[jamiguel77]

and i solved the ordering/sorting: