topic Please help - calculation incorrect for backlog in DAX Commands and Tips

Please help - calculation incorrect for backlog

Deeks — Mon, 07 Aug 2023 15:28:27 GMT

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

Re: Please help - calculation incorrect for backlog

Gengar — Mon, 14 Aug 2023 08:21:46 GMT

Hi Deeks ,

Try something like this:

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

Best regards,

Gengar

Re: Please help - calculation incorrect for backlog

Deeks — Mon, 14 Aug 2023 16:15:38 GMT

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.