Forum Discussion

Helper I

8 years ago

Solved

Difference between two rows

Hi, I need help in order to solve a problem trying to calculate the differences between two rows in Power BI. My tables look like: Date Orders Index 01/01/2017 85...

Need Help

Zubair_Muhammad

8 years ago

Hi SSS

Using DAX you can add this calculated column to get desired results

=
VAR NextIndex = Table1[Index] + 1
RETURN
    Table1[Orders]
        - CALCULATE (
            VALUES ( Table1[Orders] ),
            FILTER ( ALL ( Table1 ), Table1[Index] = NextIndex )
        )

oldandnew

Frequent Visitor

2 years ago

I have a similar problem.

I have 2 different datasets (for example sake, let's say volume table and ranking table). In the volume dataset, I have a measure that calculates the sum of the volume for each material based on an indicator column if it was received or issued. In the ranking table, the plant, material, plant volume limit, and the plant volume limit change date. I created a column in the ranking table called ranking that gives a numerical rank of the oldest plant volume limit change date from earliest (rank 1) to the latest for each material at each plant. I would like to accomplish 2 things:

Calculate the change in plant volume limit between 2 dates for each material and each plant (i.e. the plant volume limit change between rank 1 & 2 as well as 2 & 3 for each material at each plant).
Show the volume measure in the ranking table for each material at each plant. When I currently pull it, it shows the sum of all the volumes for every row. How do I fix this?

Here is the ranking table