Forum Discussion

Bandersnatchrix's avatar
Bandersnatchrix
New Member
3 years ago

Getting incremental values from cumulative figures

Hi,

 

I have a data set that records expected final fee and percentage complete for a number of projects, the table records one line per project per month.

Both the final fee and the percentage can go up or down as estimates are revised.

Each project has it's own unique project number.

A project will usually (but not always) have an entry for every month the project is live, even if there was no change on the project in that month.

 

I need to extract the incremental value change for each month, which will effectivly be:

(fee x percentage) - (fee [of previous entry for this project] x percentage [of previous entry for this project] )

 

It would be best if I could bring that through as part of the power query to add an additional column with the incremental change value, if that is not possible, the second best solution would be to add a column in DAX with the 3rd best solution doing as a measure.

 

Any help would be greatly appriciated.

 

Many thanks.

 

2 Replies

  • ProjectIDMonth ClosedFeePercentage CompleteCumulative Fee
    55366801/09/201801000
    55366801/10/201801000
    55366801/11/201801000
    55366801/12/201801000
    55366801/01/2019182.5100182.5
    55366801/02/2019182.5100182.5
    55366801/03/2019182.5100182.5
    55366801/04/2019182.5100182.5
    55368101/01/20192115000
    55368101/02/20192115000
    55368101/03/20192115000
    55368101/04/20192115000
    55368101/05/20192115000
    55368101/06/20192115000
    55368101/07/20192115000
    55368101/08/20192115000
    55368101/09/20192115000
    55368101/10/20192115046.429817.83
    55368101/11/20192490039.439818.07
    55368101/01/20202490039.439818.07
    55368101/02/20202490039.439818.07
    55368101/03/20202490010024900
    55368101/04/20202490010024900
    55368301/11/201801000
    55368301/12/201801000
    55368301/01/201916200000
    55368301/02/201916200000
    55368301/03/201916200000
    55368301/04/201916200000
    55368301/05/201913548000
    55368301/06/201913548000
    55368301/07/201913548000
    55368301/08/20191350000.11148.5
    55368301/09/20191350000.11148.5
    55368301/10/20191350000.11148.5
    55368301/11/20191350000.11148.5
    55368301/01/20201350000.11148.5
    55368301/02/20201350000.11148.5
    55368301/03/20201350000.11148.5
    55368301/04/20201350000.11148.5
    55368301/05/202013500048.2765164.5
    55368301/06/202013500048.2765164.5
    55368301/07/202013500052.9971536.5
    55368301/08/202013500052.9971536.5
    55368301/09/202013500052.9971536.5
    55368301/10/202013500052.9971536.5
    55368301/11/202013500052.9971536.5
    55368301/12/202013500052.9971536.5
    55368301/01/202165911.510065911.5