Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I want to be able to get inventory to reflect what is being used. So the next lines should be 25 , 23, 22 , and so on<<
@DDWoods Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
1 | apple | 3 | 18 | 15 |
2 | orange | 1 | 20 | 19 |
3 | grape | 4 | 10 | 6 |
4 | apple | 2 | 15 | 13 |
5 | orange | 5 | 19 | 14 |
6 | peaches | 1 | 3 | 2 |
7 | mangos | 3 | 7 | 4 |
8 | apple | 6 | 13 | 7 |
9 | grape | 7 | 6 | 1 |
@Greg here is an example in data text of what I am trying to accomplish. As I go down my table to able to stock levels reduce. Example is apples in the table.
Hi @DDWoods ,
What's your final expected result? Could you please provide some special examples to explain it base on provided sample data? Do you want to get a visual to display the inventory change or something else? It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
@v-yiruan-msft basically I'm trying to get inventory to reflect as it used from earlier dates for different items. The final result I'm trying to achieve is seeing how many complete orders I have and what I need to make other orders complete. I will try to load a PBI file late to get visual to what I am saying .
Hi @DDWoods ,
Looking forward to your reply and sample pbix file, please exclude the sensitive info in the shared file before share. Thank you.
Best Regards
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |