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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
dp32
Helper I
Helper I

Use parameter in new column

Hi, I would like to use a parameter in a formula for a new column. However, the column is always empty.

Here is an example:

 

2019-11-16_08-25-42.png

 

 

 

What is missing? Thanks in advance!

1 ACCEPTED SOLUTION

Hi @dp32 ,

 

Power BI itself cannot support to write back to database. You could use PowerApps to do it:
https://querypower.com/2017/04/04/exporting-power-query-tables-to-sql-server/

Or you could use third party softwares like Acterys.

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

Has there been any update to this? I am trying to use the What If Parameter to establish an "evaluation date" for completion of certain tasks. So I need it to write back to individual records to then compare the actual completion date to the evaluation date established by the user. I don't think a calculated measure would help me in this scenario. I was able to create a column using the two What If Parameters (Evaluation Day and Evaluation Month) but it is populating 01/01/2020 because the default values for both my parameters are set at 1. 

v-eachen-msft
Community Support
Community Support

Hi @dp32 ,

 

Column shows static values. So you need to create a measure to show it.

Measure = 
SELECTEDVALUE('Table'[Value])*Parameter[Parameter Value]

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

Hm... Thanks but this is not exactly what I want. I really need to write back the data to the table. My workaraound is now indeed to create a measure, however, it does not solve my real business issue.

So if Power BI cannot solve this problem, only solution would then to do this in an SQLServer, or?

Hi @dp32 ,

 

Power BI itself cannot support to write back to database. You could use PowerApps to do it:
https://querypower.com/2017/04/04/exporting-power-query-tables-to-sql-server/

Or you could use third party softwares like Acterys.

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.
amitchandak
Super User
Super User

What is the parameter here? All slicer joined to the table will pass automatically.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

I don't have a key relationship there, so not sure how I can use your suggestion?
I have added screenshots to my original post to better explain what I am trying to achieve.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.