Caluclated Column from single paramter value

Calculated column has to be static after data source refresh, so Parameter will only change with the whole dataset, correct?

If you want Parameter to be picked up from slicer then you would need to create a table for all possible Parameter values and filter that accordingly. It may also be possible to calculate table on the fly each time it's used, but I suppose that would be a performance killer. 

Are you looking for DAX or M solution here?

Hi difolt 

Columns can not be dynamic. They are get loaded at first load only.

If you want to make something dynamic then you need to create measure.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.