Forum Discussion

Deeks's avatar
Deeks
Frequent Visitor
3 years ago

Please help - calculation incorrect for backlog

Hi, 

I am trying to calculate the amount that should be "backlog", so it has not been shipped yet. My current formula adds up everything up to the current week's date. I'd like it to add any amount that is new/backlog, but not shipped. For example, if a sales order has been marked as shipped, it should not be counted in the following week's backlog total. So, mathematically I'd want new+backlog-shipped as a total for each week. I have attached my dataset below. 

 

BacklogDataset 

DAX Measures

2 Replies

  • Gengar's avatar
    Gengar
    Resolver I
    3 years ago

    Hi Deeks ,

     

    Try something like this:

    Backlog Amount2 = CALCULATE ( [OverallValue], FILTER('OOR','OOR'[New/Backlog] = "Backlog"&&[isShipped]=FALSE())) + 0

    Best regards,

    Gengar

     

    • Deeks's avatar
      Deeks
      Frequent Visitor
      3 years ago

      Hi Gengar 
      Thank you for your response, it didn't quite work as I need it to, but I have found a workaround for this now, using original code.