Forum Discussion
Solved
Table key in from-to form
We have metodology like this (around 500.000 rows and over 2000 met variables): met1 rn1 1.1.2014 1.1.2028 met1 rn1 1.1.2018 1.1.2020 met1 rn2 1.1.2016 1.1.2028 m...
olijo , Try a new measure like
Sumx (Table1, Sumx(filter(Table2, Table2[RN] = Table1[RN] && Table2[Date]>= Table1[Start Date] && Table2[Date]<= Table1[Enddate]), Table2[Value]))
amitchandak
Super User
Super Userolijo , Try a new measure like
Sumx (Table1, Sumx(filter(Table2, Table2[RN] = Table1[RN] && Table2[Date]>= Table1[Start Date] && Table2[Date]<= Table1[Enddate]), Table2[Value]))