The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello,
I would like to create a DAX measure which will calculate booking value as sum of ending backlog + sum of shipments - sum of beginning backlog, but only in case there will values of beginning and ending backlog in pivot table. In case there will be only beginning backlog value, then the booking will be 0 or blank. Total value of booking column will be calculated in the same logic - so in case the ending backlog of certain row will be missing, then the whole row will be calculated as 0.
See the printscreen with final expected result I need in Power BI visualisation:
I enclose dataset below as well.
Thank you very much in advance.
Best regards,
Tomas
BeginningBacklog | EndingBacklog | Fiscal_Year | Fiscal_Week_Num | Source | PROD_LINE | Coverage$ | ITEM_NUMBER | WAREHOUSE | CUSTOMER_NAME | FY-FW |
5/4/2024 | 5/11/2024 | 2024 | 19 | Shipments | 1759 | - | OP | EMEA | C5 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Shipments | 1759 | 47 | U1 | EMEA | C4 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Shipments | 1759 | - | T | EMEA | C3 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Shipments | 1759 | 1,907 | T | EMEA | C3 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Shipments | 1759 | 715 | S | EMEA | C3 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Shipments | 1759 | 1,192 | S | EMEA | C3 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Shipments | 1759 | 1,143 | OP | EMEA | C5 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Beginning Backlog | 1759 | 8,453 | U1 | EMEA | C4 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Shipments | 1759 | - | S | EMEA | C3 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Shipments | 1759 | 7,430 | OP | EMEA | C5 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Shipments | 1759 | 3,242 | OP | EMEA | C5 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Shipments | 1759 | 339 | U2 | EMEA | C4 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Shipments | 1759 | 408 | U2 | EMEA | C4 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Ending Backlog | 1759 | 417 | OP | EMEA | C5 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Ending Backlog | 1759 | 7,295 | T | EMEA | C3 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Ending Backlog | 1759 | 8,988 | OP | EMEA | C5 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Ending Backlog | 1760 | 1,928 | Q | APAC | C2 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Shipments | 1753 | 17,697 | U3 | APAC | C4 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Shipments | 1753 | 332 | U3 | APAC | C4 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Shipments | 1753 | 415 | OP | APAC | C5 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Shipments | 1753 | 27,802 | Q | APAC | C2 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Shipments | 1753 | - | OP | KOREA | C5 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Shipments | 1753 | 16,823 | U1 | APAC | C4 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Beginning Backlog | 1752 | 497 | OP | EU | C5 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Beginning Backlog | 1752 | 297 | OP | EU | C5 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Beginning Backlog | 1752 | 276 | A | EU | C1 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Beginning Backlog | 1760 | 7,815 | Q | KOREA | C2 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Beginning Backlog | 1759 | 1,790 | Q | KOREA | C2 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Beginning Backlog | 1759 | 6,587 | EE | KOREA | C2 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Beginning Backlog | 1753 | 8,881 | EE | KOREA | C2 | 2024-19 |
5/4/2024 | 5/11/2024 | 2024 | 19 | Shipments | 1753 | 15,431 | EE | KOREA | C2 | 2024-19 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Beginning Backlog | 1752 | 2,017 | OP | EU | C5 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Beginning Backlog | 1752 | 380 | T | EU | C3 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Beginning Backlog | 1752 | 1,190 | T | EU | C3 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Beginning Backlog | 1752 | 669 | T | EU | C3 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Beginning Backlog | 1752 | 551 | S | EU | C3 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Beginning Backlog | 1752 | 950 | A | EU | C1 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Beginning Backlog | 1752 | 69 | B | EU | C1 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Beginning Backlog | 1752 | 159 | S | EU | C3 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Beginning Backlog | 1752 | 8 | S | EU | C3 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Beginning Backlog | 1752 | 1,078 | S | EU | C3 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Ending Backlog | 1752 | 950 | A | EU | C1 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Ending Backlog | 1752 | 69 | A | EU | C1 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Ending Backlog | 1752 | 380 | T | EU | C3 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Ending Backlog | 1752 | 159 | T | EU | C3 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Ending Backlog | 1752 | 669 | T | EU | C3 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Ending Backlog | 1752 | 8 | S | EU | C3 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Ending Backlog | 1752 | 1,078 | S | EU | C3 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Ending Backlog | 1752 | 1,190 | S | EU | C3 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Ending Backlog | 1752 | 551 | S | EU | C3 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Ending Backlog | 1752 | 1,848 | EE | EU | C2 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Shipments | 1752 | 1,319 | A | EU | C1 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Ending Backlog | 1752 | 430 | S | EU | C3 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Ending Backlog | 1752 | 12 | S | EU | C3 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Ending Backlog | 1752 | 1,274 | S | EU | C3 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Ending Backlog | 1752 | 734 | S | EU | C3 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Ending Backlog | 1752 | 1,353 | EE | EU | C2 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Ending Backlog | 1752 | 1,058 | U2 | EU | C4 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Ending Backlog | 1752 | 1,331 | U1 | EU | C4 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Ending Backlog | 1752 | 1,383 | A | EU | C1 | 2024-20 |
5/11/2024 | 5/18/2024 | 2024 | 20 | Ending Backlog | 1752 | 1,266 | B | EU | C1 | 2024-20 |
5/18/2024 | 5/25/2024 | 2024 | 21 | Beginning Backlog | 1752 | 380 | S | EU | C3 | 2024-21 |
5/18/2024 | 5/25/2024 | 2024 | 21 | Beginning Backlog | 1752 | 1,190 | S | EU | C3 | 2024-21 |
5/18/2024 | 5/25/2024 | 2024 | 21 | Beginning Backlog | 1752 | 669 | S | EU | C3 | 2024-21 |
5/18/2024 | 5/25/2024 | 2024 | 21 | Beginning Backlog | 1752 | 551 | S | EU | C3 | 2024-21 |
5/18/2024 | 5/25/2024 | 2024 | 21 | Beginning Backlog | 1752 | 950 | B | EU | C1 | 2024-21 |
5/18/2024 | 5/25/2024 | 2024 | 21 | Beginning Backlog | 1752 | 69 | B | EU | C1 | 2024-21 |
5/18/2024 | 5/25/2024 | 2024 | 21 | Beginning Backlog | 1752 | 159 | S | EU | C3 | 2024-21 |
5/18/2024 | 5/25/2024 | 2024 | 21 | Beginning Backlog | 1752 | 8 | S | EU | C3 | 2024-21 |
5/18/2024 | 5/25/2024 | 2024 | 21 | Beginning Backlog | 1752 | 1,078 | S | EU | C3 | 2024-21 |
5/18/2024 | 5/25/2024 | 2024 | 21 | Beginning Backlog | 1752 | 1,319 | B | EU | C1 | 2024-21 |
5/18/2024 | 5/25/2024 | 2024 | 21 | Beginning Backlog | 1752 | 12 | S | EU | C3 | 2024-21 |
5/18/2024 | 5/25/2024 | 2024 | 21 | Beginning Backlog | 1752 | 430 | S | EU | C3 | 2024-21 |
5/18/2024 | 5/25/2024 | 2024 | 21 | Beginning Backlog | 1752 | 1,848 | EE | EU | C2 | 2024-21 |
5/18/2024 | 5/25/2024 | 2024 | 21 | Shipments | 1752 | 1,383 | B | EU | C1 | 2024-21 |
Solved! Go to Solution.
Ok,
I solved it eventually...
Ok,
I solved it eventually...
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
32 | |
20 | |
16 | |
16 |
User | Count |
---|---|
56 | |
51 | |
36 | |
35 | |
31 |