Forum Discussion

hmeegada's avatar
hmeegada
Frequent Visitor
7 years ago

Needed Help!!! Data cleaning/transforming

Hi, 

I'm new in BI community and was looking for a way to transform my disoriented dataset into a tabluar format

 

Current formatexpected formatIs this something that can be acheived within BI, or should it be done outside BI, I have numerous files in similar format, looking for sugesstion or help on how to go forward. Thanks in advance

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Aren't you only needing lines where the first column has D? Then get all the lines the filter (in Powerquery) the lines with D in that column. Then remove the not needed columns.

    • hmeegada's avatar
      hmeegada
      Frequent Visitor
      7 years ago

      Hi, I also need date listed in H, and the number next to it.

       

      I would also need "I" row elements to appear in a column

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        ah ok, that's a different story :-)

         

        As with another similar request a few days ago, it's fairly complex as you can't reference "other rows" in PowerQuery. So you can't really tell "go to the NEXT line and get a value". Generally speaking, you can't guarantee a sequential order. Granted, you can create a key column and put a number, but, even in DAX, how can you tell which row where to look for the three values to put in column?

        IF you could have a way to put the same value on all of the rows of the same "group" (the D ones and the corresponding I) it could be done via DAX...