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
Dynamic 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_db23 minutes agoNew MemberNew226Views2likes2CommentsReintroduce 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_Ku3 hours agoNew MemberNew100Views14likes1CommentSupport Fabric SQL Database with workspace-level inbound Private Link
Fabric SQL Database supports tenant-level Private Link but not workspace-level Private Link. Securing a small number of databases therefore requires enabling Private Link across the entire tenant, in...WorkFull224 hours agoAdvocate INew10Views1like0CommentsImprove Relationship UI Wording to Better Reflect Filter Propagation Direction
The current relationship dialog can be confusing because the UI labels "From" and "To" do not always align with users' linguistic expectations regarding filter propagation. As per document : Relation...v-varunvv5 hours agoMicrosoft EmployeeNew18Views4likes0Comments