what-if parameter to a column

[Anonymous]

I have a What-if parameter which takes whole number (1, 2, 3, 4 ,5)

I want to pass the value of it to add to a calculated column like below. but seems i'm unable to do it

ParameteredDate = Merge1[ACTUAL_DATE]+ 'Accuracy Parameter'[Accuracy Parameter Value]

[mahoneypat]

Calculated columns are refreshed only when the data are refreshed and don't respond to slicers.  However, you are showing a table visual in your pic, so perhaps you mean you want a measure (that will respond to slicer selections) to be used to create a column in your table visual.  Is that correct?  The terminology can be confusing.  If so, you can use a What-If parameter to dynamically change the range of dates your table visual shows.

You just need to use an aggregation on your date (e.g., MIN(Table[Actual Date]) and add that to your parameter value in your measure.

ParameterEndDate = MIN(Table[Actual Date]) + [Accuracy Parameter Value]

Regards,

Pat

[Anonymous]

@mahoneypat 
i tried  as you siggested, but did not work.

[mahoneypat]

You need to do it in a measure, not in a calculated column.  What-If Parameters can't be used in calculated columns.

Regards,

Pat

[Fowmy · Accepted solution]

@Anonymous 

You cannot add Parameter value to Calculated Column. Calculated Columns are computed and stores in advance so it cannot be dynamic. 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn 

[Anonymous]

@Fowmy 

Thank you so much for replying.

is there any other way to pass user input to a calculate date field

[Fowmy]

@Anonymous 

Sorry, currently there is no option to incorporate user selection in calculated columns.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn