Forum Discussion

Alirezam's avatar
Alirezam
Helper V
5 years ago
Solved

Subtracting 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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Alirezam 

     

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Alirezam 

 

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.

  • Alirezam's avatar
    Alirezam
    Helper V
    5 years ago

    Hi,

    This solution is so clever and I used it in Power query however, exactly the same 'step' seems not to work in 'dataflow' and the 'new column' returns 'error'. any idea why the same command does not work in dataflow? thanks