Parameter Populated Column

[anmarti3]

Hi all,

Is there any way to have have a fixed value in a column that is defined by an input paramater? I need to have that same fixed value down the entire column for all rows so I can use that value in other caclulated columns. 

Thanks!

[Anonymous]

no, but why you need to have it in a fixed column? Just use the parameters (what if).

[Mariusz]

Hi @anmarti3 

All you need to do is go to query editor, create a parameter and add a custom column ( where = parameter name ), please see "Added Column" step for reference.
Later you can invoke the parameter by going to Edit Queries > Edit Parameters 

Sure please see the attached with the solution.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.