Forum Discussion
Helper IISpilt the Columns in Power bi Table
Helper IIVijay_A_Verma wdx223_Daniel Anonymous hi i have created dimension table for split data
could you please sujjest new column(Term_Text coumn ) for display vol,invol,and blank data.
Most Valuable ProfessionalMethod will stay the same. There is no change in that.
- Mahamood0218
Vijay_A_Verma in above pic i have created Dimension table so we can try with coding is it possible?
- Mahamood0218
Vijay_A_Verma when i try with as your sujjestion data is divided (i got the my requirment) but when i apply and close in transform edit mode again it shows the below error
so i have a another technique by using dimension table we can summarize all columns into single unit then we can divide vol and invol from table
DimAR = ADDCOLUMNS(SUMMARIZE(TextDetails,[action_id],[action_reactive]), "TestResult", IF(FIND("-",[action_reactive],1,0) > 0, LEFT([action_reactive],
FIND("-",[action_reactive],1,0)-1)))above code will work as per our requirment or do u have any idea ,pls suggest me
Thanks&Regards
- Vijay_A_Verma
Just follow the step give by me and code will be automatically generated - You can select Action_Reasoncolumn - In PQ, Add column menu - Extract - Text before delimiter - Put "-" without quotes in Delimiter and under Advanced options - Select from the end of the input
If you need step, use this where Source will have to be replaced with your previous step
= Table.TransformColumns(Source, {{"Action_Reason", each Text.BeforeDelimiter(_, "-", {0, RelativePosition.FromEnd}), type text}})- Mahamood0218
if i used above code and previous method after that when i close and save in edit query i will be getting erro like below
that is main reason i have created dimension table and it is possible by applying if else statement for spilt the data?