alex_olcese's avatar
alex_olcese
New Member
4 years ago
Status:
New

Dynamic Measure Names

Hello everyone. First time posting. I'd like to offer an idea to improve PowerPivot (and all of PowerBI) functionality - Dynamic Measure Names using Excel formulas. Every January, I have to create a new measure for the new year so that it displays properly in a PowerPivot. Let's use "2022 Sales" as an example. I'm guessing I'm not alone in this. It would be great to be able to name the measure as =year(today())&" Sales") which would return "2022 Sales" and therefore, update dynamically each year. Having this functionality would also allow users to dynamically adjust the description of other measures already in the pivot table "2021 Sales", "2020 Sales", "2019 Sales", etc... by using a similar formula: =((year(today())-1)&" Sales" for 2021 Sales =((year(today())-2)&" Sales" for 2020 Sales I know there are workarounds but adding this capability would open up endless possibilities for users in an easy, already understood manner.

Recent ideas