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])
niteshtrehan89's avatar
niteshtrehan89
Icon for Helper III rankHelper III
5 years ago

first change the G_TYPE to text and then create a calculated column

 

New G_TYPE= "G" & Table[G_TYPE]