Forum Discussion
Spilt the Columns in Power bi Table
Hi Experts, I have a PBI Table Active Table with two coulmns(Action_ID and Action_Reactive ) my requirement is by using "Active Table" i want to create Dimension table along with New Column as T...
Vijay_A_Verma in above pic i have created Dimension table so we can try with coding is it possible?
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