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.
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
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |