Forum Discussion
Filtering between unrelated tables
Hello, Appreciate if someone could please provide some help on the below: I have two tables, the first is a large list of documents. There are many columns for other fields, e.g. start date, ...
Mezga , Try a measure like
measure =
var _1 = summarize(filter(generate(Table1, Table2), Table2[Date] >= Table1[Start Date] && Table2[Date] <= Table1[Finish Date]), "_1",[STARTED DOCUMENTS])
return
sumx(_1,[STARTED DOCUMENTS])
Thanks for your response amitchandak
I'm trying to filter Table 2 based on Table 1 fields, e.g. the discpline of the document - "Electrical" for instance. Not sure if your measure will achieve that, unless there's something I'm missing.
Table 2 still needs to have all dates from start to finish.
How would I get the calculated totals in Table 2 to only look at a specific discipline type, and ignore the rest?