Forum Discussion
murali5431
Helper III
Helper IIIParameter value not picked up in calculated column
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 Val...
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 )
Deku
Super User
Super UserCalculated 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?
murali5431Helper III
Helper IIIDeku 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.
- Deku
And do what with it?
- 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?