Forum Discussion
Calculate with values from different tables
Hello Community, (big thanks already for the endless answers i got by browsing this forum!) Here is my problem - i want to create a measure that would output the total rebate in the example belo...
Anonymous thanks but not there yet .
1) i cannot merge both tables as data goes way beyond my example.
2) there seem to be an error with your formula as in the RELATED formula, the turnover table is not a choice, only the tables that "feeds" into the order table are a possibility (so the rebate table values are accepted).
cheers and again thanks for the support!
play with related and relatedtable function
Related works for many to 1
relatedtable works for 1 to many.
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.