Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Analytika
Regular Visitor

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?Parameters.png

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

Capture2.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

3 REPLIES 3
v-shex-msft
Community Support
Community Support

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

Capture2.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

How do you do this in 2020 ?  

Hi v-shex-msft 

 

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

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors