Sort Rows by Positive and Negative

[Anonymous]

Hello,

Please see below requirements,

How can i sorting out rows ,so that matching positive and negative numbers are found and sorted next to each other?

BEFORE
Date	Type	Amount	Result
9/1/2015	R	45	Y
13/01/2016	B	50	Y
13/01/2016	X	-62	N
9/1/2015	R	-45	N
9/1/2015	BA	80	Y
9/1/2015	B	-50	N
8/2/2005	X	62	Y
9/1/2015	BA	-80	N
AFTER
Date	Type	Amount	Result
9/1/2015	R	45	Y
9/1/2015	R	-45	N
13/01/2016	B	50	Y
9/1/2015	B	-50	N
13/01/2016	X	-62	N
8/2/2005	X	62	Y
9/1/2015	BA	80	Y
9/1/2015	BA	-80	N

[AkhilAshok]

You could try creating a new measure which gives Abs(SUM(Table[Amount])), and sort Ascending based on this measure.

[Anonymous]

Hi Akhil,

thank you so much for your suggestion.Is it possbile i can use the same formula in Power Query (Language M).? 

Thanks

[Anonymous]

Thank you so much Akhil.

[v-cherch-msft · Accepted solution]

Hi @Anonymous

You may add a custom column in query editor and then sort by the custom column.

if [Amount] < 0 then [Amount]*-1 else [Amount]

 

Regards,

Cherie

[Anonymous]

Thank you so much Cherie.