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])
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Check like

New Column = MAXX(filter('TABLE', 'TABLE'[G_TYPE]= earlier('TABLE'[G_TYPE])),[SAL_C])
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Amit

Thank you very much , it work fine now.

Paul