Add a function to Power BI similar to the INDIRECT Function in Excel, so that you can dynamically refer to measures and tables by means of a string.
3 Comments
- Jayden_SandersNew Member
This would be a huge help to our organization as well. It would allow us to dynamically reference measures within DAX. It would allow for a lot of automation, especially for large dashboards with multiple KPIs.
Essentially it would be the opposite of NAMEOF(). Instead of getting the name of a measure as a string, it takes as string with the name of a measure, and returns the measure or string.
- AnonymousNot applicable
I've encountered a similar situation. I have been following some examples of how to make text that displays currently applied filters. This involves repeating the same code block for each column that is to be checked, and each block contains multiple references to the column, as when using the result of FILTERS the original column reference is used.
If I could store a column reference in a VAR, this would mean only referring to it once per block, and this would allow the rest of each repeated block to be identical. This would make maintaining and updating the measure much easier. I suspect the block could even be changed to only appear once via CONTATENATEX tricks.
It also seems that this would be an important building block for user functions: Microsoft Idea (powerbi.com) which would be much more powerful if they were able to use functions that need a column or table reference instead of just manipulating values.
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Access Variable Library in Semantic Models
Enable the Variable Library as a centralized location for storing all environment‑specific variables, allowing us to adjust them for promotion scenarios (e.g., from dev to prod) without relying on de...FreddyH9 hours agoAdvocate IINew920Views31likes2CommentsEnhance Fabric Pipeline Monitoring with Parent-Child Pipeline Lineage and Parameter Visibility
Currently, Microsoft Fabric Pipeline monitoring lacks several capabilities that are available in Azure Data Factory, making troubleshooting and operational support challenging in enterprise environme...dwramreddy10 hours agoRegular VisitorNew8Views0likes0CommentsDynamic ADLS-Gen2 path input for Spark Jobs Main definition file
I would like the ability to add a dynamic input box on a spark job definition's "Main Definition File" "ADLS-Gen2 path". this would be useful to set base and variable paths across all spark jobs...mfink_db14 hours agoNew MemberNew238Views2likes2CommentsReintroduce Tenant/Capacity Switch to Control "Users can create Plan items" Post-GA
During the Preview phase of Fabric Plan items, administrators had access to a dedicated tenant/capacity setting: "Users can create Plan items". With General Availability (GA), this granular administr...Sri-Surendra_Ku17 hours agoNew MemberNew106Views14likes1Comment