Subtract values from different rows

Question

Hi,&nbsp;I have a table that tracks company headcount (Headcount_C) and I also have a Month_Year column and a Rolling_Month column.I would like to know the difference between each month, using either the Month_Year or Rolling_Month.&nbsp;Rolling Month&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Month_Year&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Headcount_C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (Difference)1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; October 2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -212&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; September 2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6021&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +33&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; August 2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6018&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+1&nbsp;I am struggling to get this working, I have tried using PreviousMonth and DatesInPeriod, but I can't seem to get the result I want.I have also surrounded my statement with IF(Headcount_C&gt;0,............Is there a way to get this working using the rolling month?&nbsp;All help appreciated.

v-ljerr-msft · Answer

Hi&nbsp;RichWyeth,&nbsp;According to your description, you should be able to use the formula below to create a calculate column in this scenario. (Assume your table is called "Table1".)Difference = 
VAR rm = Table1[Rolling Month]
VAR hc = Table1[Headcount_C]
RETURN
    hc
        - CALCULATE (
            MAX ( Table1[Headcount_C] ),
            ALL ( Table1 ),
            Table1[Rolling Month]
                = rm + 1
        )&nbsp;Regards

Forum Discussion

Subtract values from different rows

1 Reply

Related content

Subtraction calulation

Subtracting from two difference tables

Subtract values from different rows

Date Different return wrong value

Subtract values from different rows