Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Bookings Calc Help

Hi, looking for a better way to build this calc out.. This formula is to create a quarterly weekly bookings number with one slicer.  I have been able to do it using two slicers but wondering if ther...
Need Help
v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi Anonymous ,

 

What is the mathematical calculation logic of [Begining Backing] and [Ending Backing]?

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Lionel,  Thank you for reaching out.  To help explain my situation i am attaching the pbi images  (i would share the Pbi file, but not sure how to do that)  , The first image shows how the formula works when the two date slicers are correctly chosen for start and end date.  But my goal is to have one slicer do this.  Also, if i select more than one week, the formula doesn't work because it does not sum the total shipments for all the periods of the range.  Thank you for your time and help.

    Below are images of the relationship, table in pbi, and the formulas for the fields you asked for.

     

    The last image is an excel file showing the answer and on row 33, the answer if we select the start date as the first week and the end date as the last/current week.  FOr some reason the backlog calcs are correct, but the shipments is not, it does not subtotal all the transactions for the range...