Forum Discussion
Row over row logic
A bit stumped here. Trying to enhance a dataset with a column that uses some logic. The data is coming from general ledger entries with the the two (or more) accounts an document posts to. Wh...
Got it. I think this works, but I created this as a measure now instead of a calculated column like the previous approach. I set this up to represent your "Flag(end)." This could be easily modified for the other scenario if that's desired, though. Here's the new calc:
Flag Final = IF(SUMX(FILTER(ALL(Sheet1),Sheet1[Index]<= SELECTEDVALUE(Sheet1[Index])),Sheet1[Amount]) = 0,1)
And the output:
Let me know if this works.
Ben
Awesome!
I modified to a calculated column and switched to flagging the start.
Flag = IF(SUMX(FILTER(ALL(Table1),Table1[Index]< EARLIER(Table1[Index])),[Amount]) = 0,1)
Thanks again!