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.
Cannot understand your requirement at all.
I need another filter for unique values in the table occurences, I have an identifier column that I created with concat. (&) on the occurences table.
Can you help me?
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)