Forum Discussion
Nuage
4 years agoNew Member
Power BI custom text view and grouping
Hello, I have a Power BI problem however I have no reasonable knowledge of the tool and was kind of forced to use it as my csv data file was too large for Excel so I'm hoping for some guidance from t...
- 4 years ago
Thanks for the tips. You've given me some things to learn about. Turns out I discovered an easier way (for me, at least) by using a transform and a split, then showing only the split columns that I needed.
Your input was appreciated all the same.
wdx223_Daniel
4 years agoCommunity Champion
NewStep=Table.SplitColumn(PreviousStepName,"Column3",each List.FirstN(List.Skip(Text.Split(_,"\"),2),3),{"L1","L2","L3"})
- Nuage4 years agoNew Member
Thank you I'll give this a shot. In reference to the last array, is it safe to presume I can replace the L1,L2 etc with wildcards?