Forum Discussion
pass a parameter to a function
Can I pass parameter value selected from a list of years?
Hi antoniofallucca,
You want to refer to the selected value of query parameter in DAX formula, right? Currently, we cannot use a parameter in a calculated measure/column directly. To work around this requirement, we could create a query to store parameter value in a dataset, and then pass this dataset value to function. For detailed steps, please see: Passing Parameters in measures
Best regards,
Yuliana Gu
1 Reply
- v-yulgu-msftMicrosoft Employee
Hi antoniofallucca,
You want to refer to the selected value of query parameter in DAX formula, right? Currently, we cannot use a parameter in a calculated measure/column directly. To work around this requirement, we could create a query to store parameter value in a dataset, and then pass this dataset value to function. For detailed steps, please see: Passing Parameters in measures
Best regards,
Yuliana Gu