Forum Discussion
Solved
separate values into columns
Hello community, I'm a new user of Power BI and would like to know how to move values from from column to additional columns that will contain only , closed, stand, none, enhanced values, see pictu...
Like this? Pbix file attached.
Hi, if you have space in Promoted Headers, you have to use #"Promoted Headers" as reference so replace Values step with this:
= List.Buffer(List.Sort(List.Distinct(#"Promoted Headers"[StateOfProceedingID])))
Like this? Pbix file attached.
Thank you
You're welcome.
Hello,
When I add the step "Values" it says "expression error:the name 'PromoteHeaders' wasn't recognised. Make sure you spelled correctly..... but my step before is "Promoted Headers"... How did you make step *Values"?
Hi, if you have space in Promoted Headers, you have to use #"Promoted Headers" as reference so replace Values step with this:
= List.Buffer(List.Sort(List.Distinct(#"Promoted Headers"[StateOfProceedingID])))