Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello Fabric Community:
I had received some help from Ibeddlin on some RT and last stock day calculations in this file. What I am hoping to get is a table/matric that shows each store, thier products and current inventory with the amount remaining onhand. The tricky part is I'm hoping not to scroll thru all the dates inbetween. My page one is an example of the results I'm looking to get. Thank you Idedblin and all others https://drive.google.com/file/d/1uq5bLdv5kXkjz3cQ07G8iKNJ0TGkHDOH/view?usp=sharing for your help!
Solved! Go to Solution.
Hi @Whitewater100 ,
I’ve made a test for you reference:
1\Create a new measure
Bal_On_Hand = sum(WHINV[Qty_On_Hand])-CALCULATE(
SUM('Orders'[Qty]),REMOVEFILTERS('Orders'),
Orders[Loc_ID]<=Max(Store_Location[Loc_ID]) && Orders[Prod_ID]=max(Products[Prod_ID])
)
2\Add a table
Best Regards
Bof
Good Day Bof!
Thank you for providing this measure. I think it will be great, but have one question. If several stores have the same open date, will the measure still work or would that require a revision?
Thank you for your reply!!
Hi @Whitewater100 ,
I believe the formula will still be effective, as it is sorted by Loc_ID.
Best Regards,
Bof
Hi @Whitewater100 ,
I’ve made a test for you reference:
1\Create a new measure
Bal_On_Hand = sum(WHINV[Qty_On_Hand])-CALCULATE(
SUM('Orders'[Qty]),REMOVEFILTERS('Orders'),
Orders[Loc_ID]<=Max(Store_Location[Loc_ID]) && Orders[Prod_ID]=max(Products[Prod_ID])
)
2\Add a table
Best Regards
Bof
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
26 | |
10 | |
10 | |
9 | |
6 |