Forum Discussion
Get Values from other Rows in the same Table.
Hi ebuttazzi,
We can create a calculated column based on your data.
Column = CALCULATE(SUM(Table1[ID]),FILTER(ALL(Table1),Table1[Class]=EARLIER(Table1[Class])))-Table1[ID]
Then we can get the result as you need.
For more details, please check the pbix as attached.
Regards,Frank
Hi ebuttazzi,
We can create a calculated column based on your data.
Column = CALCULATE(SUM(Table1[ID]),FILTER(ALL(Table1),Table1[Class]=EARLIER(Table1[Class])))-Table1[ID]
Then we can get the result as you need.
For more details, please check the pbix as attached.
Regards,Frank
Hey Frank, First, i would like to thank you for the solution, i was not aware of the existence of the EARLIER func.
Your solution would work great if not the fact that ALL(table) messes values up when there are more than one group. I manage to work aroud it using:
ID counterpart = CALCULATE(SUM(table[id]);FILTER(FILTER(table[group] = EARLIER(table[group]));table[class]=EARLIER(table[class]))) - table[id]
I just wondered if my solution for the group filtering (that works) is the most efficient.
Again, Thank you a lot for helping me out with this issue, i wish you the best.
Enzo