Forum Discussion

antoniofallucca's avatar
8 years ago
Solved

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-msft's avatar
    v-yulgu-msft
    Microsoft 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