Hi Team,
I created few parameter for my direct query report, one with text, one with date/time both are working fine.
Now I have created one decimal value parameter, let say I pass 1.02 in that parameter, then what format I need to pass in advance editor.
For example: we are using "&m&" for text value( here m hold value for text parameter in advance editor).
Similar what syntax I need to pass to fetch value of decimal parameter.
Thanks in advance!!
is this for a custom SQL query against a direct query source? You need to use Text.From() to convert your value to something you can use in the query.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
125 | |
74 | |
65 | |
53 | |
53 |
User | Count |
---|---|
199 | |
104 | |
88 | |
79 | |
77 |