Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi guys!
Can anyone help me?
I have around 7.000 lines with data - a XML file.
Every 4 rows the "block" starts again. It's always "group, name, number, data"
Something like this:
Column1 - Column2
1234 - Group
XYZ - Name
ID - Number
May/20 - Date
5678 - Group
ABC - Name
ID - Number
Apr/20 - Date
1234 - Group
XYZ - Name
ID - Number
May/20 - Date
I've tried to convert to columns by example but no success 😞
Any tips? 😄
Solved! Go to Solution.
Brazil is great, I'm helping you from Portugal! 😀
Sorry if I skipped some detailed steps...
You need to go here:
After that, write the following code (for each column you gonna need), adapting your if-statement to each column.
E.g.:
Column Name = if [Column 2] = "Name" then [Column 1] else null
Column Id = if [Column 2] = "Id" then [Column 1] else null
...
Um abraço! 😀
Thanks a lot! 🙂 🙂 Worked fine!! 😁
Hi @Anonymous ,
I think I've found a receipt for this!
Used the following sample data:
Then created 4 custom columns with the following code:
if [Column 2] = ##Column_to_be_created then [Column 1] else null
After that, you need to fill-down the first custom column created and fill-up the last one and the penultimate
To finish, filter the third column to eliminate null values
Note: This solution may not be feasible for other scenarios, and it is better to confirm that you do not "lose" data through the process...
Any questions, don't hesitate!
Best Regards,
Eduardo
[Edited because sample data was wrong.]
One more thing, @edugoncalves ...
I'm trying to remove the null's with your tip but I couldn't...lol
I have to put the Fill up and down after the code to add custom? I've tried shift + enter but returns me an error ....I could only fill down the first collumn but not the others 😞
Hi Edu!
Greetings from Brazil 😉
I couldn't add the first line (if [Column 2] = ##Column_to_be_created then [Column 1] else null)
..I'm kind of newbie at PBI.
I've tried to insert your string at custom column but showed me "expected literal token" 😕
Brazil is great, I'm helping you from Portugal! 😀
Sorry if I skipped some detailed steps...
You need to go here:
After that, write the following code (for each column you gonna need), adapting your if-statement to each column.
E.g.:
Column Name = if [Column 2] = "Name" then [Column 1] else null
Column Id = if [Column 2] = "Id" then [Column 1] else null
...
Um abraço! 😀
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
31 | |
27 |
User | Count |
---|---|
92 | |
50 | |
44 | |
40 | |
35 |