Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Case 964 How to recode GROUP_TYPE to SAL_C ?

Hi All   I al still struggle on how to recode GROUP TYPE to Staff.   My expected result in Yellow color :- Some one have give me the script below :- New Column = calculate(firstnon...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Check like

    New Column = MAXX(filter('TABLE', 'TABLE'[G_TYPE]= earlier('TABLE'[G_TYPE])),[SAL_C])
FarhanAhmed's avatar
FarhanAhmed
Icon for Community Champion rankCommunity Champion
5 years ago

just thinking If G_TYPE is the same number coming after SALC "G" then why not create a new calculated column

 

something like

 

New SAL_C= "G" & Table[G_TYPE]

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi sir

    I try your expression , and using auto fill i still get error.

     

    • FarhanAhmed's avatar
      FarhanAhmed
      Icon for Community Champion rankCommunity Champion
      5 years ago

      the data type for this column should be Text instead of Whole Number.