Forum Discussion
Priesling
Nov 12, 2024Copper Contributor
Trying to use a user input within a DAX query
Hello Everyone.
Currently trying to use a userinput made in Copilot studios from the user and implementing it in the DAX query. However it is not working. Do any of you have some knowledge on how to succeed?
code snippet.
DEFINE
VAR UserInput = Var2
EVALUATE
TOPN(
100,
SELECTCOLUMNS (
FILTER (
'Table',
'Table'[Adresse] = UserInput
),
"Ejendom", 'Table'[Ejendom],
"Adresse", 'Table'[Adresse]
)
)
No RepliesBe the first to reply