The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
I'm writing calculated groups vs target and I'm replacing one word from measure name.
SUBSTITUTE("[" & SELECTEDMEASURENAME() & "]", "Act", "Tgt")
Do you know if there is a function to convert string "[Measure Tgt]" to measure format without quotation marks: [Measure Tgt]?
Thank you for you're answers
That's a pity. I wanted to do this more elegant than have 50 SWITCH rows.
DAX can't take a name of a measure and evaluate it using a mechanism like EVAL in other languges. In other words, it's not possible to have dynamically evaluated strings. If you want to do something similar, you have to use SWITCH.