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.
I am trying to rename the columns of a table using the values from another table.
GetIssues
Column1.fields.customfield_10041 | Column1.fields.customfield_10042 | Column1.fields.customfield_10043 |
xxx | xxx | xxx |
xxx | xxx | xxx |
field
Id | Name |
Column1.fields.customfield_10041 | a |
Column1.fields.customfield_10042 | b |
Column1.fields.customfield_10043 | c |
I want to rename the first table as the below table.
a | b | c |
xxx | xxx | xxx |
xxx | xxx | xxx |
Note
1. I am doing a Jira analysis
2. Not all the columns are in the format of Column1.fields.customfield_10041
Can you please help me to do this?
Thanks.
@v-chuncz-msft
Hi @Dilesha08
Please see the attached file with a solution
Thanks, that helped me a lot!
@Mariusz I get the following error when I apply changes.
Actually I want to match the exact column name from table 2 and add it to table 1. Also, the specific columns are not in order. Only we can match them with their id.
Hi @Dilesha08
Sorry, but I have no idea what that error is without investigating.
Have you applied the steps as in the file? does it work in PQ?
@Mariusz Yes, I have followed up on your steps. But the issue is I want to take the data from another table, not from a list. I don't have an idea to do it.
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 |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |