topic Re: Parameter value not picked up in calculated column in DAX Commands and Tips

Parameter value not picked up in calculated column

murali5431 — Mon, 24 Mar 2025 09:00:58 GMT

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

Re: Parameter value not picked up in calculated column

Deku — Mon, 24 Mar 2025 09:04:29 GMT

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?

Re: Parameter value not picked up in calculated column

murali5431 — Mon, 24 Mar 2025 09:13:18 GMT

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!

Re: Parameter value not picked up in calculated column

murali5431 — Mon, 24 Mar 2025 09:15:06 GMT

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

Re: Parameter value not picked up in calculated column

Deku — Mon, 24 Mar 2025 09:38:11 GMT

And do what with it?

Re: Parameter value not picked up in calculated column

murali5431 — Mon, 24 Mar 2025 09:46:57 GMT

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

Re: Parameter value not picked up in calculated column

murali5431 — Tue, 25 Mar 2025 09:35:32 GMT

Deku would you be able to help?

Re: Parameter value not picked up in calculated column

Deku — Tue, 25 Mar 2025 09:53:45 GMT

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 )

Re: Parameter value not picked up in calculated column

murali5431 — Tue, 25 Mar 2025 15:26:14 GMT

Thank you Deku