Forum Discussion
what-if parameter to a column
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
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 🙂
6 Replies
- Fowmy
Super User
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 🙂
- mahoneypat
Microsoft Employee
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
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
