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