query parameter

Anonymous — Mon, 11 Jan 2021 13:59:54 GMT

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

Re: query parameter

wdx223_Daniel — Tue, 19 Jan 2021 01:00:39 GMT

how about adding a Vaule function like this

period=value(@period)

Anonymous

Re: query parameter

Anonymous — Tue, 19 Jan 2021 14:10:17 GMT

wdx223_Daniel , thank you !

topic Re: query parameter in DAX Commands and Tips

query parameter

Re: query parameter

Re: query parameter