Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I have a table in my model that contains parameters (i.e : (key, value)):
The table has 2 columns :
- ParamName : Name of the parameter (string)
- ParamValue : Value of the parameter (may be string, integer, date)
How can I create measure that returns the ParamValue based on a given ParamName ?
I tried that, but it does not work :
Measure =FIRSTNONBLANK(PARAM[ParamValue ];PARAM[ParamName ]="TheNameOfTheParameter")
Thanks
Solved! Go to Solution.
Hi @jct999 -
You can use LOOKUPVALUE for this:
Measure =
var __PN = SELECTEDVALUE(PARAM[ParamName])
RETURN
LOOKUPVALUE ( PARAM[ParamValue], PARAM[ParanName], __PN )
Hope this helps
David
Hi @jct999 -
You can use LOOKUPVALUE for this:
Measure =
var __PN = SELECTEDVALUE(PARAM[ParamName])
RETURN
LOOKUPVALUE ( PARAM[ParamValue], PARAM[ParanName], __PN )
Hope this helps
David
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |