Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I found a solution to rename column names automatically based on content of a certain column using the following command:
#"Renamed Columns" = Table.RenameColumns(Source,{{"Value", Source[ReportDate]{0}}}),
Although this works, if also screws up the tables because the "name reference" will change. This results in the following error/problem:Before i had dates 22 and 23. After updating i have dates 22 and 24. Because 23 changed to 24, Power Bi doenst reconizes the value to use anymore. Is this possible to fix using some other lines of code?
Solved! Go to Solution.
Hi @Sander123,
By my test and confirmed, this is a limitation in Power BI currently.
When we refer to other values to rename the column name which option is complex, we will encountr this error. We only to click "Fix this" and drag the column again.
Best Regards,
Cherry
Hi @Sander123,
By my test and confirmed, this is a limitation in Power BI currently.
When we refer to other values to rename the column name which option is complex, we will encountr this error. We only to click "Fix this" and drag the column again.
Best Regards,
Cherry
User | Count |
---|---|
98 | |
90 | |
78 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |