query parameter

[Anonymous]

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

[Anonymous]

@wdx223_Daniel , thank you !

[wdx223_Daniel · Accepted solution]

how about adding a Vaule function like this

period=value(@period)

@Anonymous