Forum Discussion

ndavis42's avatar
ndavis42
New Member
9 months ago
Solved

Get over 3 week backlog from Power BI

Hello,

I'm attempting to get a over/under numeric value for a 3 week backlog.  To start out I got the 3 week rolling total using:

 
3 Weeks Rolling Total =
CALCULATE (
    SUM ( WeeklyOPCo[New] ),
    DATESINPERIOD ( 'Date Table'[Date], MAX ( 'Date Table'[Date] ), -21, DAY )
)
 
Using this I would like to get the amount from a weekly dashboard.  
 
Example of Data:
W1 BacklogNew3 Wk RollCalc 15 dayW2 BacklogNew3 Wk RollCalc 15 dayW3 BacklogNew3 Wk RollCalc 15 day
862114619 808147534 636234495 

 

The value I'm looking for is Backlog - 3 Wk Roll.  For example W1 Calc 15 Day would be 243, W2 would be 274, and W3 would be 141. 

 

Thank you for any assistance!

Need Help
  • rohit1991's avatar
    rohit1991
    9 months ago

    Hii ndavis42 

     

    You already have the 3-week rolling total. To get the “over / under” backlog, simply subtract that rolling value from the current backlog in a new measure.

    Example:

    Backlog vs 3 Week Roll =
SUM ( WeeklyOPCo[BacklogNew] ) - [3 Weeks Rolling Total]

     

2 Replies

  • rohit1991's avatar
    rohit1991
    Icon for Super User rankSuper User
    9 months ago

    Hii ndavis42 

     

    You already have the 3-week rolling total. To get the “over / under” backlog, simply subtract that rolling value from the current backlog in a new measure.

    Example:

    Backlog vs 3 Week Roll =
SUM ( WeeklyOPCo[BacklogNew] ) - [3 Weeks Rolling Total]

     

    • ndavis42's avatar
      ndavis42
      New Member
      9 months ago

      Thank you!  I'll never get used to summing a single value like that.