Forum Discussion

arb1782's avatar
arb1782
Icon for Helper III rankHelper III
5 years ago
Solved

Challenge with split columns by delimiter

Hi   I have data across 6 columns and the data is in two formats depending on the data source. I want to achieve the following:   Category Value Category 1 X, x and x Category 2 Y, y ...
Need Help
PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

Hi arb1782 

Can you please supply examples of the data as it actually appears once brought into PBI with data in Format1 and Format2 in the same columns.  Showing it as 2 separate formats has confused me, I don't understand how the data is really structured.

Can you expand on how you have 1 table but 2 sources?  How are you actually querying this table?

Phil

arb1782's avatar
arb1782
Icon for Helper III rankHelper III
5 years ago

Hi PhilipTreacy Greg_Deckler 

 

I've solved this problem now. Thanks for your input.

 

arb

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi  arb1782 ,

     

    Glad to hear that your issue is solved now,could you pls mark the reply as answered to close it?

     

    Thank you.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!