How to create new GROUP field ?

Hi Anonymous ,

Try to create the new column like this:

New Column_ =
IF (
    "G" & CONVERT ( [G_TYPE], STRING ) = [SAL_C]
        || [SAL_C] = BLANK (),
    "G" & CONVERT ( [G_TYPE], STRING ),
    [SAL_C]
)

Attached the modified sample file in the below, hopes to help you.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

you can create a new column in Power Query to meet your conditions.

if [YOUR GTYPE COLUMN] = null
or [YOUR GTYPE COLUMN] = ""
and ([YOUR SAL_C COLUMN] = null
or [YOUR SAL_C COLUMN] = "")
then null
else 

if [YOUR GTYPE COLUMN] = null
or [YOUR GTYPE COLUMN] = ""
and ([YOUR SAL_C COLUMN] <> null
or [YOUR SAL_C COLUMN] <> "")
then [YOUR SAL_C COLUMN]
else 

if [YOUR SAL_C COLUMN] = null
or [YOUR SAL_C COLUMN] = ""
then "G" & Number.ToText([YOUR GTYPE COLUMN])
else 
[YOUR SAL_C COLUMN]