Is this what you want?
1. Create parameter 'Old cheese price'
2. Create calculated field using the parameter IIF([Cheese]="Old Cheese",[Old cheese price],[Price])
Please find attached the sample workbook for your reference.
cheese price.twbx 13.3 KB
Yes! Thank you so much! I really appreciate all the effort you put into this!
What if I wanted to do this for multiple cheese in the same calculation? Because
IIF([Cheese]="Old Cheese",[Old cheese price],[Price])
AND IIF([Cheese]="Young Cheese",[Young cheese price],[Price])
would not work.
In that case, you have to use 'CASE' (Or multiple IF).
WHEN 'Old Cheese' THEN [Old cheese price]
WHEN 'Young Cheese' THEN [Young cheese price]
cheese price v2.twbx 13.5 KB
Sorry for my late response.
Thank you so much for answering my question.