Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
68 | |
48 | |
45 | |
18 | |
15 |