Forum Discussion
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 Is this something that can be acheived within BI, or should it be done ou...
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
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...