Powerbi Calculated Column Parameter value passing with no table relationship

Question

I am having a scenario and want to pass parameter values in calculated columns and there should not be any relationship between parameter table and master table

And this are the calculated columns which I have created

Title = 
var related_year = Parameter[Parameter Value]
var date_closed = Roles[Date Closed]+365
var if_1 = if(Roles[Status] = "Open", date_closed,Roles[Date Closed]) 
var if_2 = if(related_year = YEAR(TODAY()),TODAY(),date(related_year,12,31))
return if((if_1>if_2),title,0)

How can I pass parameter value without any relationship in the model as Tableau? 

Answer 1

It will be calculated at the time when the table is loaded,becasue it cannot be dynamically responsive

Want to learn more about Power Bi, Refer & learn Power bi

Also, check out our YouTube video to know the data visualization basics and best practices with Power BI