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.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Allow Bottom-Up Hierarchy Expansion in Power BI Matrix for Financial Statements
Allow Bottom-Up Hierarchy Expansion in Power BI Matrix for Financial Statements Hi, I would like to request an enhancement to the Power BI Matrix visual that allows hierarchies to be expanded from t...Barbarini1 hour agoRegular VisitorNew3Views0likes0CommentsOneLake Catalog full-text and content search
Why is it not possible to search OneLake by item description or even content? So I was thinking about how a user can find a table if they don't know in which lakehouse it is located? Why can't you se...TePe19 hours agoHelper IVPlanned1.1KViews21likes5Comments