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 "id"'s for the same "juristicentityid"
(I think I need to add another filter where I show "???")
Example of what I need:
JohannSteyn , try a measure like
Sumx(filter(Table, [juristicentityid] = earlier([juristicentityid]) && [id] >= earlier([id])) ,[amount to distribute])
1 Reply
JohannSteyn , try a measure like
Sumx(filter(Table, [juristicentityid] = earlier([juristicentityid]) && [id] >= earlier([id])) ,[amount to distribute])