Forum Discussion
Alirezam
Helper V
Helper VSubtracting the rows in Query based on a specific column
Hi guys, I want to make this change in Query and not on the table in Desktop view: I have a table as attached here, it has multiple values in "Point Name" columns, I need to subtract the "Point Val...
Add an index from 0, then create the following custom column, and remember replace error and change data type.
if ([Meter] = #"Added Index"{[Index]+1} [Meter]) then ([Reading]- #"Added Index"{[Index]+1} [Reading]) else ""Check attached pbix for detail.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super UserAlirezam , I am assuming you need the previous row. Check if this article can help
if not
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
AlirezamHelper V
Helper VHi,
Thanks but this is not answering what I asked. Here is the table I have and the 'Diff' column is what I want to create. As you see, the function of difference should apply for each 'Meter' separately.