Parameter value not picked up in calculated column

[murali5431]

Hi,

I have a column which reads as below:

Date allowed for KPI Met = If('Table'[Mode]="Air",'Table'[Date],(If(WEEKDAY('Table'[Date])<=3,'Table'[Date]+Select_days_to_add[Select_days_to_add Value],if(WEEKDAY('Table'[Date])<=6,'Table'[Date]+Select_days_to_add[Select_days_to_add Value]+2,'Table'[Date]+Select_days_to_add[Select_days_to_add Value]+1))))

Select_days_to_add[Select_days_to_add Value] is from the parameter defined. Despite changing the values of parameter, the "Date allowed for KPI Met" remains the same. Could you please let me know a workaround for this issue.

I am not able to create a measure as date value has many duplicate values.

Thanks in advance for the help!

Regards,

Muralidhar

[Deku]

Calculated tables and columns are evaluated on semantic model refresh. Parameters on report pages cannot dynamically updates these, only measures

What effect are you trying to achieve?

[murali5431]

@Deku Thanks for the response. I am trying provide the user a dropdown of values to choose from; numbers between 1 to 10, 3 being default, and capture this value in Select_days_to_add[Select_days_to_add Value] and add it to the date value.

Hope this helps!

[murali5431]

@Deku This value has to be added to Table'[Date] column.

[murali5431]

and display that as a new column in the table. It will be then shown in a table visual. 

[murali5431]

@Deku would you be able to help?

[Deku · Accepted solution]

This can just be a measure you add to your table

KPI Met = 
var selectedDays = SELECTEDVALUE( Select_days_to_add[Select_days_to_add Value] )
var dt = SELECTEDVALUE( 'Table'[Date] )
var addDays = 
SWITCH(
   true,
   WEEKDAY('Table'[Date])<=3, 0,
   WEEKDAY('Table'[Date])<=6, 2,
   1
)
return 
IF(
   SELECTEDVALUE( 'Table'[Mode] ) = "Air", 
   dt, 
   dt + addDays
)
   

[murali5431]

Thank you @Deku 

[Deku]

And do what with it?