Forum Discussion
Solved
How do create a measure for a table using a sum calculation from another table?
For example, let's say I have two tables. The first one is 'Dates': School Date School A 10/15 School A 10/22 School B 10/11 School B 10/18 School C 10/12 School C 10...
BBHouston , new column in table 1
countx(filter(table2, Table2[School]= table1[School] && table2[Enrollment Date] <= Table1[Date]),Table2[School])
BBHouston , new column in table 1
countx(filter(table2, Table2[School]= table1[School] && table2[Enrollment Date] <= Table1[Date]),Table2[School])
amitchandakIt worked!! Thank you thank you! 🙂