Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
5 years ago

Visual sorting

Hi, I have created a calculated coloumn using the below Dax Status = IF('GCSP & MSL'[Moved?]="Yes","Moved", IF( SEARCH("TBC",'GCSP & MSL'[Additional info],1,0)>0,"Under Discussion", IF( SEARCH("No...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Super User
5 years ago

vjnvinod , Try like

sortingstatus = Switch(True() ,
'GCSP & MSL'[Status]="Moved",1,
'GCSP & MSL'[Status]="In Markets, Other SMU",2,
'GCSP & MSL'[Status]="To Move",3,
'GCSP & MSL'[Status]="Under Discussion",4,
'GCSP & MSL'[Status]="Exceptions",5,10)

  • vjnvinod's avatar
    vjnvinod
    Impactful Individual
    5 years ago

    amitchandak 

     

    it doesn't work either

     

    see below same error

     

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      vjnvinod , what is there between column name and Switch . I see two = .

       

      This is a column in table 

      • vjnvinod's avatar
        vjnvinod
        Impactful Individual
        5 years ago

        amitchandak 

         

        you provided the double "=" forumla in the first reply to this thread, i thought you might have some logic for that

         

        see below you response

         

        this because the sort column is baed on the same column

         

        create a new column

        Status 1= MSL'[Status]=

         

        sortingstatus = IF('GCSP & MSL'[Status]="Moved","1",
        IF('GCSP & MSL'[Status]="In Markets, Other SMU","2",
        IF('GCSP & MSL'[Status]="To Move","3",
        IF('GCSP & MSL'[Status]="Under Discussion","4",
        IF('GCSP & MSL'[Status]="Exceptions","5","")))))

         

        now sort Status 1 on sortingstatus  and use Status 1 in your report