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 ParameteredDate = M...
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
i tried as you siggested, but did not work.
mahoneypat
Microsoft Employee
Microsoft EmployeeYou need to do it in a measure, not in a calculated column. What-If Parameters can't be used in calculated columns.
Regards,
Pat