Please provide more details, if possible share the workbook.
1 of 1 people found this helpful
When you make a join you will get the option on how you want to make the join. In that list the last entry helps to create a join by calculation. Here you can make your calculation which is just like entering a calculated field. As shown by Hari you will end up in that screen once you are done.
*If this helps, then please mark it Helpful and Correct to close this thread
Is there a way to allow the allow the calculated field to appear in the list instead of re-typing the formulae using create join calculation?
When I create the calculated field, the formulae is dependent on a parameter. If I were to re-type the formulae using join calculation, reference to parameter doesn't work.
Unfortunately not. You need to key in the calculation and you cannot enter parameter here because this join is done before you get into the data sheet. But you use parameter based on a dimension right. You might as use that dimension and create the join and once you are in, you can use the parameter to reference.
You can upload a sample workbook to assist you better.