Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 outside BI, I have numerous files in similar format, looking for sugesstion or help on how to go forward. Thanks in advance
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.
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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |