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 was wondering if someone could help.
I know with power query you can mass replaces values. I was wondering if it was possible to do this for individual values?
For instance, I have 20 rows that and each have the letter A within a column. I would like to individually be able to alter them.
So that I can do something similar to this:
Row 1 A = A1
Row 2 A= A2
Row 3 A= A3
Thanks,
Boycie92
Hi @Boycie92,
In Query Editor mode, please use the "Split Column" option twice. First time, split out A, second time, get a separate column listing row number.
Then, combine these two columns.
=[Column2]&Text.From([Column3])
Best regards,
Yuliana Gu
Hi @Boycie92,
Have you achieved your desired result? If yes, would you please accept the helpful reply as an answer or share your solution?
Best regards,
Yuliana Gu
Apologies for the delay in responding.
Your solution would work but within my column I have other values that I need to use. (A) Is just an example.
So if I was to create another column I would need to somehow tell it if you see A show me A1 or A2 etc. However if the other values in the original column are not A the show me blank
Now I could use a custom column to do this, the problem I have is telling it to split the A values?
Thanks for the help,
Boycie92
Hi @Boycie92,
Could you try this:
=if [Column2]="A" then [Column2]&Text.From([Column3]) else null
Please pay attention the case sensitive. For more advice, please share more sample data and show us your expected output.
Regards,
Yuliana Gu
I am sorry when i said "However if the other values in the original column are not A the show me blank"
What I actually wanted was show me the original values within the original column if it’s not A. If it is A show me the values from the new column (A1, A2, etc)
Sorry again, I hope that makes much more sense!
Thanks,
Boycie92
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |