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.
Remaining Inventory after Finalized orders Subtracted
Hello Community:
I have created a table using some basic measures, see attached. I am looking for suggestions on how to write DAX as a table function for my main visual. Inventory is stored in multiple locations and orders in this case are subtracted from inventory if they are noted as finalized.
I have the main visual which I'm looking to produce as a DAX table function.
Thank you!
Solved! Go to Solution.
Hi, @Whitewater100
new Table =
SUMMARIZECOLUMNS(Products[Product],WH_Loc[WH_Area],WH_Name[WH Name],
"total wh qty",SUM(WH_Inv[WH_Qty]),
"finalized order qty", CALCULATE(SUM(Orders[Order Qty]),Orders[Order Status]="finalized"),
"balance of INV(oh-final oq)",SUM(WH_Inv[WH_Qty])-CALCULATE(SUM(Orders[Order Qty]),Orders[Order Status]="finalized")
)
Please find link to report. Sorry it was not shared correctly the first time!
https://drive.google.com/file/d/1VQurjakljRyT1x9bBtHzFF_UjsDw3xbY/view?usp=sharing
Hi, @Whitewater100
new Table =
SUMMARIZECOLUMNS(Products[Product],WH_Loc[WH_Area],WH_Name[WH Name],
"total wh qty",SUM(WH_Inv[WH_Qty]),
"finalized order qty", CALCULATE(SUM(Orders[Order Qty]),Orders[Order Status]="finalized"),
"balance of INV(oh-final oq)",SUM(WH_Inv[WH_Qty])-CALCULATE(SUM(Orders[Order Qty]),Orders[Order Status]="finalized")
)
Thanks very much! Nice job:-)
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 |
---|---|
42 | |
26 | |
22 | |
13 | |
8 |
User | Count |
---|---|
75 | |
50 | |
47 | |
17 | |
17 |