Forum Discussion

antoniofallucca's avatar
antoniofallucca
Helper I
8 years ago
Solved

pass a parameter to a function

Can I pass parameter value selected from a list of years?    
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

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