Forum Discussion
related() issue
Normal : revenue_BU = [revenue]/related(Rate[Exchange Rate]) in the case [Exchange Rate]=6.95 But Line 1: [revneue_Bu]= 603,668.6 / 6.95=86,858.79 <> 99,669.2 (calculate [Exchange Rate]=6.05672164 ...
Hi,
Can you try creating a new column with the IF Statement that you have and then use the SUM function. If the Related Function does not seem to work, you would need to make sure that the relationship should be properly configured between the Columns of the two tables.
Best Regards,
Vignesh M
If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue 🙂