160475Helper I4 years agoSolvedcocatenated value Dears, i have 2 columns one is branch gender where the values are 1 or 2 the second column is branch number where the values from branch 1-10 i would like to creat a new column where the values w...Show MoreBA_Pete4 years agoHi 160475 , In Power Query, try a new custom column with this calculation: Text.Combine({Text.From([branch]), Text.From([gender])}, "-") If this causes you an issue with query folding, then use this instead: Text.From([branch]) & "-" & Text.From([gender]) Pete
BA_Pete4 years agoHi 160475 , In Power Query, try a new custom column with this calculation: Text.Combine({Text.From([branch]), Text.From([gender])}, "-") If this causes you an issue with query folding, then use this instead: Text.From([branch]) & "-" & Text.From([gender]) Pete
BA_Pete4 years agoHi 160475 , In Power Query, try a new custom column with this calculation: Text.Combine({Text.From([branch]), Text.From([gender])}, "-") If this causes you an issue with query folding, then use this instead: Text.From([branch]) & "-" & Text.From([gender]) Pete
BA_PeteSuper User4 years agoHi 160475 , In Power Query, try a new custom column with this calculation: Text.Combine({Text.From([branch]), Text.From([gender])}, "-") If this causes you an issue with query folding, then use this instead: Text.From([branch]) & "-" & Text.From([gender]) Pete
Related contentCreate custom column with cocatenated valueClosing valueremove duplicate value within a rowIF Negative valueDAX for calculating retroactive values
