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 would like to know how to rename column names dynamically in my case scenario.
I have a table with column headers as CY-2,CY-1,CY,CY+1,CY+2 along with many other columns
If CY is 2020, then I need to rename the column names as
when CY is 2021, then they should get renamed as
Please, anyone has an idea ? Thanks in advance.
@Kavitha10 , Can you use the year on the column?
Even with this year and YTD , you should be able to use year from date table
Hi , thanks for your response.
I actually have CY-2,CY-1,CY,CY+1,CY+2 as measure values (because the computations changes based on slicer selection). Is it possible to rename the measures dynamically?
Hi @Kavitha10
As far as I know, there's no way to rename the measures dynamically.
Can you add some more details? So that I might be able to find an alternative method.
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |