Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
murali5431
Helper III
Helper III

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

1 ACCEPTED SOLUTION

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
)
   

Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

View solution in original post

8 REPLIES 8
Deku
Super User
Super User

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?


Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

@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!

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

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

@Deku would you be able to help?

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
)
   

Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

Thank you @Deku 

And do what with it?


Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.