Forum Discussion

niharika0913's avatar
niharika0913
Frequent Visitor
9 years ago

How can I calculate absolute difference between two consecutive numbers in a column

  Hi,   I want to calculate absolute difference of consecutive data points in a column for a filtered data. These set of values are based on 3 filters. Example, When I filter the data by Plant, Ma...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

niharika0913

 

The approach would probably be to make a calculated column (referred to as index-column), which assigns a value from 1 to n amount of rows, and then make another calculated column to get the value for index-column - 1. Does that make sense?

 

Best,

Martin

niharika0913's avatar
niharika0913
Frequent Visitor
9 years ago
Anonymous Let me know if I understand you. I tried adding an index column earlier but to fail. Logically, this set of data in the image above is filtered, hence random index number comes up when I filter the data for a Plant and a Machine. I want to calculate the difference of consecutive values for the filtered data. If I do not understand you, can you give an example on how to do this?
  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi niharika0913,

    Please try to add a rank column based on slicers. More details, please review the solution here. And you'd better share your resource table and list expected result, or your .pbix file. So that we can provide the solution which is close to your requirement.

    Best Regards,
    Angelia

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    niharika0913

     

    I understand. So, either, it has to be a dynamic index-column, or some sort of hierarchy-index-colum, so we can apply that -1 method. I've tried to figure out a smarter way to do it, but I can't come up with any DAX formula, which will solve your problem. Will let you know, if I come up with anything.