Forum Discussion

jomask's avatar
jomask
Frequent Visitor
2 years ago
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...
Need Help
  • dufoq3's avatar
    dufoq3
    2 years ago

    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])))
jomask's avatar
jomask
Frequent Visitor
2 years ago

 

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"?

dufoq3's avatar
dufoq3
Icon for Community Champion rankCommunity Champion
2 years ago

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])))
  • jomask's avatar
    jomask
    Frequent Visitor
    2 years ago

    Thank you it works 🙂