Forum Discussion
Anonymous
5 years agoNot applicable
query parameter
Hi all,
I m using DAX STUDIO to prepare queries for REPORT BUILDER but I have an issue with the parameter :
- This query works perfectly :
But when I want to parameterize the year [ANNEE] = 2019 into [ANNEE]= periode it doesn't work because of an incompatibility between numer and string (comparison operators). I suppose the string in question is this one :
Because, in the the first iteration, [ANNEE]=2019 works fine !
But in the query history, the year is wrapped with "" ?
Thanks
how about adding a Vaule function like this
period=value(@period)
Anonymous
2 Replies
- wdx223_DanielCommunity Champion
how about adding a Vaule function like this
period=value(@period)
Anonymous
- AnonymousNot applicable
wdx223_Daniel , thank you !