Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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
)
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?
@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!
and display that as a new column in the table. It will be then shown in a table visual.
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
)
And do what with it?
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |