The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi there,
I have a huge database of Inventory Management having More than one stores as well as products,
everyday stock is updating by some value(UpdateQty) and having one min value(MinQty)
I calculate values like - Out-of-Stock, Under-Stock, In-Stock using calculation (UpdateQty and MinQty),
Finally, I create a calculated column as StockCheck, which shows the status of every product.
Now I have to show all details in Matrix Chart(Row- Product, Column-Dates, Values-StockCheck),
but it shows blank values if stock is not updated on that date.
So my problem is that I have to calculate the last value on that blank values,
Stores/Dates 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Store3/A Out In under
Store3/B under In
Store4/A In Under Out
Store4/B In
Store5/A Out In
I use the following Measure but it now shows the correct value:
Can you share some sample data. If possible please share a sample pbix file after removing sensitive information.Thanks.
My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Hi Amit,
Thank you for showing interest to solve my issue.
Please find the link below to access the .pbix file
Here I have calculated all fields and show the expected output,
if blank the show previous status.
Thank You
User | Count |
---|---|
10 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
20 | |
15 | |
14 | |
10 | |
7 |