Case 964 How to recode GROUP_TYPE to SAL_C ?

[Paulyeo11]

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(firstnonblank('TABLE'[SAL_C], blank()), filter('TABLE', 'TABLE'[G_TYPE]= earlier('TABLE'[G_TYPE])))

My PBI file :-

https://www.dropbox.com/s/vsas6b4276pbwq4/GROUP%20V001.pbix?dl=0

Hope some one can share with me where go wrong ?

Paul Yeo

[niteshtrehan89]

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

New G_TYPE= "G" & Table[G_TYPE]

[amitchandak · Accepted solution]

@Paulyeo11 , Check like

New Column = MAXX(filter('TABLE', 'TABLE'[G_TYPE]= earlier('TABLE'[G_TYPE])),[SAL_C])

[Paulyeo11]

Hi Amit

Thank you very much , it work fine now.

Paul 

[FarhanAhmed]

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]

[Paulyeo11]

Hi sir

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

[FarhanAhmed]

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