Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Hi @Deeks ,
Try something like this:
Backlog Amount2 = CALCULATE ( [OverallValue], FILTER('OOR','OOR'[New/Backlog] = "Backlog"&&[isShipped]=FALSE())) + 0
Best regards,
Gengar
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.
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
82 | |
55 | |
40 | |
20 | |
12 |