Forum Discussion

CliffordAP's avatar
CliffordAP
Icon for Helper II rankHelper II
5 years ago

Row-wise Sum within a date range

Hello all, I am trying to do an aggregation of transactions that happen between people and between a date range of 7 days. I want this calculation to be done row-wise, meaning that every transactio...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

CliffordAP , Not very clear, Try a measure like

calculate(sum(Table[Amount]), filter(Table, Table[Date] >=today() -7 && Table[Date] <=today()))