Regarding Dax measure

[sujith_291183]

This is the way i do in Excel. I need a measure coloum for Backlog and Rollover.
Backlog is previos day Rollover+Current day Actual and Rollover is Currentday Backlog-Capacity.
Can you please help how to create measure for this

Wk	Date	Actual Capacity	Actual	Backlog + Today	Rollover
43	20-Oct	1,800	907	993	-
43	21-Oct	1,800	797	797	-
43	22-Oct	1,800	1,026	1,026	-
43	23-Oct	1,800	1,127	1,127	-
43	24-Oct	1,800	1,325	1,325	-
44	25-Oct	1,800	1,355	1,355	-
44	26-Oct	1,000	1,673	1,673	673
44	27-Oct	1,000	1,490	1,490	490

[juju63]

hello sujith_291183

did you try to add index 0 & index 1 (or more) and merge the query with itself ?

[sujith_291183]

Hi Omid,
Thanks for the response.
dont have the table of roll over and backlog
in excel it is calculated as per the cell.
like k5 + k8
Backlog need rollover and rollover need backlog
in excel it calculated as per cell
but in power binot able to do.
appriciate if you help this

[Omid_Motamedise]

Do you insisit to do it by Dax, or you are ok to o it by power query also?

[sujith_291183]

Yes power query is fine

[Omid_Motamedise]

use this
Rollover ='Table'[Backlog] - 'Table'[Capacity]



Backlog =VAR PreviousRollover =CALCULATE([Rollover],DATEADD('Table'[Date], -1, DAY))
RETURN PreviousRollover + 'Table'[Actual]