Forum Discussion
Solved
Filter relative to current row
Hi all, I need some help please. I think have this basic issue embedded in a more complex forumla. I have the following columns: Date 1, Date 2, Amount. I want to add a column with the sum of t...
JohannSteyn , Sorry, I think I reverted the logic
new column =
var _date = [Date1]
return
sumx(filter(Table, Table[Date2] >=_Date),[Amount])
JohannSteyn , Sorry, I think I reverted the logic
new column =
var _date = [Date1]
return
sumx(filter(Table, Table[Date2] >=_Date),[Amount])
amitchandak working! You're awesome! Thank you