Forum Discussion

murali5431's avatar
murali5431
Helper III
1 year ago
Solved

Parameter 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 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

"DAX Commands and Tips"
@Measures
DAX
  • Deku's avatar
    Deku
    1 year ago

    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
)

8 Replies

  • Deku's avatar
    Deku
    Super User
    1 year ago

    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's avatar
      murali5431
      Helper III
      1 year ago

      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!