Forum Discussion

murali5431's avatar
murali5431
Icon for Helper III rankHelper 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 Val...
"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
)
Deku's avatar
Deku
Icon for Super User rankSuper 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
    Icon for Helper III rankHelper 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!

    • murali5431's avatar
      murali5431
      Icon for Helper III rankHelper III
      1 year ago

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

      • Deku's avatar
        Deku
        Icon for Super User rankSuper User
        1 year ago

        And do what with it?