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
Deployment pipeline: Deployment rules for Direct Lake on OneLake semantic models
Currently, it is not possible to use deployment rules with Direct Lake on OneLake semantic models. The option is greyed out. Please enable this, so we can automatically change the data so...frithjof_v1 hour agoCommunity ChampionNew6KViews137likes17CommentsNative Master Data Management Solution
Microsoft Fabric currently lacks a native Master Data Management (MDM) capability, creating a gap for organizations that need to manage and govern business-critical reference data such as customers, ...bradcoles2 hours agoRegular VisitorNew212Views1like3CommentsCopy results as markdown from data grid
When copying results from a query on the SQL Endpoint or Data Warehouse I often have to convert from the tab delimited table to markdown for sharing the results via services like teams or github. It...Tom_Fosterbi3 hours agoRegular VisitorNew6Views0likes0Comments