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.
Hi, so I created a column that display "true" or "false" if the conditions are matching.
I would like to know if there is a way to create a variable, X=757_501, for example, and replace every "787_501" by this X in my formula. I would like to do this because I might often want to change this number in the future. And changing the value of 1 variable is faster than changing it 15 times in a formula.
I tried to do this through measures but it didn't work as planned
Thanks !
Solved! Go to Solution.
YES you can use veriables in dax
for example
Query Bugs = Var T = "787_501" Var ret = <put your dax here and replace each instance on text with T> Return ret
Where you need to combine your veriable in a string just use a &
fore example where you have "test 787_501" replace with "test " & T
Proud to be a Super User!
Use VAR to create variable and use substitute to replace value
Sample how
YTD Sales = Var var= "XYX" Return substitute()......
YES you can use veriables in dax
for example
Query Bugs = Var T = "787_501" Var ret = <put your dax here and replace each instance on text with T> Return ret
Where you need to combine your veriable in a string just use a &
fore example where you have "test 787_501" replace with "test " & T
Proud to be a Super User!
The answer was under my eyes since the beginning, you can't even imagine every things I tried knowing this VAR function...
Thanks
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 |
---|---|
104 | |
104 | |
87 | |
73 | |
66 |
User | Count |
---|---|
122 | |
112 | |
98 | |
79 | |
72 |