Forum Discussion

Mahamood0218's avatar
Mahamood0218
Icon for Helper II rankHelper II
4 years ago

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...
Need Help
Show and Tell
Tips and Tricks
Mahamood0218's avatar
Mahamood0218
Icon for Helper II rankHelper II
4 years ago

Vijay_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.

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Icon for Most Valuable Professional rankMost Valuable Professional
    4 years ago

    Method will stay the same. There is no change in that. 

    • Mahamood0218's avatar
      Mahamood0218
      Icon for Helper II rankHelper II
      4 years ago

      Vijay_A_Verma in above pic i have created Dimension table so we can try with coding is it possible?

      • Mahamood0218's avatar
        Mahamood0218
        Icon for Helper II rankHelper II
        4 years ago

        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