Forum Discussion
Solved
Calculate and filter using multiple tables
Hello, I have two data tables, one (I'll call it table 1) for occurrences by date, product, production line, and how long it lasted. And another one with the campaign with start and end date, lin...
This calculated column formula in the Campaigns table works
=CALCULATE(SUM(Occurences[Duration]),FILTER(Occurences,Occurences[Line]=EARLIER(Campaign[Line])&&Occurences[Product]=EARLIER(Campaign[Product])&&Occurences[Date]>=EARLIER(Campaign[Start date])&&Occurences[Date]<=EARLIER(Campaign[End Date])))Hope this helps.
Had i understood your question, i would have answered it earlier itself.
How may I help you understanding? I don't know how else to explain it 😕
(There is also a language barrier where some information might be getting lost)