Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Making new table using data in other table

Main purpose of this post is to find out how to rearrange my data so I can display it in my report. I can not use any extended DAX functions or Power query because of lack of any experience in this area. So coming to my task.

I have one table that I parsed from XML . They all have same attributes and keys such as returnValue.data.i.v.Element.Text. So they signed up in one column despite the fact that they all have different type of data. I want to separate them but maintaining data integrity so that one follows after another. Originally data was under one date (like 22.01.2022-AST-129000-Chocofood). My idea was to cycle through every element where each element has its own iterator for AST is i = 0; 129300 is j = 1 and Chocofood is k = 2, and every one of them iterates to 3(i += 3) also moving each element to 3 separates columns in new table. But I can not realize it in  Power BI.Help me out with it please. 

If you need any additional data I will response immeadiately.

2 Replies

  • HI Anonymous ,

     

    Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

    If the information is sensitive please share it trough private message.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi,can you reply to my private message ?