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
)
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?

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

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

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

      Deku would you be able to help?

      • Deku's avatar
        Deku
        Icon for Super User rankSuper User
        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
)