Use parameter in new column

[dp32]

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:

What is missing? Thanks in advance!

[Anonymous]

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]

Hi @dp32 ,

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

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

[dp32]

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?

[v-eachen-msft · 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.

[amitchandak]

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

[dp32]

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.