Forum Discussion
sujith_291183
1 year agoRegular Visitor
Regarding Dax measure
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 he...
Omid_Motamedise
1 year agoSuper User
use this
Rollover ='Table'[Backlog] - 'Table'[Capacity]
Backlog =VAR PreviousRollover =CALCULATE([Rollover],DATEADD('Table'[Date], -1, DAY))
RETURN PreviousRollover + 'Table'[Actual]