Forum Discussion
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]
Community SupportHi Anonymous ,
You can create a column like this:
New Column =
CALCULATE (
MAX ( 'TABLE'[SAL_C] ),
FILTER ( ALL ( 'TABLE' ), 'TABLE'[G_TYPE] = EARLIER ( 'TABLE'[G_TYPE] ) )
)
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.
Hi Ying
When i apply your acript into my actual pbi file . the result is wrong.
my pbi file , ref to Tab "Recode SAL_C"
https://www.dropbox.com/s/46wxf6wk6wb13g1/SI_TDS_V050.pbix?dl=0
Thank you for your help
Paul
- v-yingjl
Hi Anonymous ,
Based on the sample file, I want to comfirm some logic about this case(For example [G_Type = 1]):
When [SAL_C] is blank or equals G1, the value of the new column should be G1, otherwise the value of the new column should be the same as [SAL_C].
Is it right or anywhere wrong?
Best Regards,
Community Support Team _ Yingjie LiHi Ying
Thank you for your help , yes you are correct.
paul