Forum Discussion

Analytika's avatar
Analytika
Regular Visitor
9 years ago
Solved

Creating a Calculated column based on the value of selected Parameter

Hello everyone

 

I am trying to change the values of a calculated column based on the value of a selected paremeter. So, I have set up the parameters , I have saved my Powerbi file as a template so that the paremeters apply on loading the file.

 I am trying to create a new column = ExposureValue * {Selected Parameter}  and I am unable to. Can you help?

  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Analytika,

     

    Parameters doesn't work on dax function, but you can use it at query editor.

     

    Sample: Add new column to use the parameter

     

    Regards,

    Xiaoxin Sheng

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Analytika,

     

    Parameters doesn't work on dax function, but you can use it at query editor.

     

    Sample: Add new column to use the parameter

     

    Regards,

    Xiaoxin Sheng

    • Analytika's avatar
      Analytika
      Regular Visitor

      Hi v-shex-msft 

       

      That worked perfectly! Thank you very much and have a great day!

       

    • Anonymous's avatar
      Anonymous
      Not applicable

      How do you do this in 2020 ?