Forum Discussion
Solved
ALLEXCEPT with a range
Hi, I'm new here. I am trying to add a colum that will show the SUM of "amount to distribute" IF 1 - the "juristicentityid" is the same AND 2 - the "id" is equal to or larger than all of the other...
JohannSteyn , try a measure like
Sumx(filter(Table, [juristicentityid] = earlier([juristicentityid]) && [id] >= earlier([id])) ,[amount to distribute])
JohannSteyn , try a measure like
Sumx(filter(Table, [juristicentityid] = earlier([juristicentityid]) && [id] >= earlier([id])) ,[amount to distribute])