When i try column sort with 10 row of rec i also get error msg ?

[Anonymous]

Hi All

Mr Amit have try to help on below post :-

https://community.powerbi.com/t5/Desktop/GL-CODE-Sorting-get-error/m-p/1600958#M648119

I try to create a very simple PBI file to check will it come out error msg ? below is my data set :-

Amit have help me create below expression :-

GL_CODE_Sort =

SWITCH(

TRUE(),

PNL[GL_CODE (groups)] ="REV" ,1,

PNL[GL_CODE (groups)] ="COGS",2,

PNL[GL_CODE (groups)] ="OTHER",3,

PNL[GL_CODE (groups)] ="EXP",4,

5

)

When i try to use above filed as sort column :-

below is the error msg :-

i am using Dec 2020 version.

My PBI file :-

https://www.dropbox.com/s/mc1uuep7if1rbe9/PBT%20GL%20VER0019%20ask%20how%20to%20create%20PNL%20field...

Hope some one can help me to test , and see will you get error msg ?

My expect result is Sort the GL_CODE (groups) field in following sequences :-

REV

COGS

OTHER

EXP

Paul

[ryan_mayu · Accepted solution]

@Anonymous 

Please see two workarounds in the attachment. hopt this is helpful.

[Anonymous]

Hi Ryan

You are very smart.

Thank

Paul

[amitchandak]

@Anonymous , GL_CODE_SORt is create on GL_CODE (groups) , it will not work .

Do this a new column GL_CODE (groups)1

GL_CODE (groups) 1 = [GL_CODE (groups)]

Sort this on GL_CODE_SORT  and use in viusal

Refer my video I dicussed this : https://www.youtube.com/watch?v=KK1zu4MBb-c

[Anonymous]

Hi Amit

Can you pls send the PBI file , so that i can understand what you mean.

Paul