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 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
Solved! Go to Solution.
how about adding a Vaule function like this
period=value(@period)
@Anonymous
how about adding a Vaule function like this
period=value(@period)
@Anonymous
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 |
---|---|
45 | |
26 | |
22 | |
12 | |
7 |
User | Count |
---|---|
73 | |
51 | |
45 | |
16 | |
12 |