Forum Discussion

ndavis42's avatar
ndavis42
New Member
8 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]...
Need Help
  • rohit1991's avatar
    rohit1991
    8 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]

     

rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
8 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
    8 months ago

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