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,
I am currently try to track our stock with power BI, however am stuck on a problem about data capture.
For example I would like to have a monthly check in total stock value.
Situation:
Week 1
Product A stock qty: 10
Product B stoct qty: 10
Product C stoct qty: 10
Checking date: Feb 1
Week 2
Product A stock qty: 5 ---- sold 5pcs
Product B stoct qty: 10 ---- no data update
Product C stoct qty: 15 ---- sold and restock
Checking date: Feb 8
Could anyone provide advice on whether this is possible with Power BI at the moment please?
Much Appreciated!
Solved! Go to Solution.
HI @natt,
If timestamp column stored normal date format, you can try to use summarize function to summary records by year month.
Summary table = SUMMARIZE ( ADDCOLUMNS ( Table, "Year Month", FORMAT ( Table[timestamp], "yyyy MM" ) ), "Year Month", [Year Month], "Product id", [product id], "Stock", [stock], "Summary QTY", SUM ( Table[qty] ) )
Then you can simply find out specific records by filter on 'year month'.
Regeards,
Xiaoxin Sheng
How are your data?
Everything is in one table?
HI @natt,
If timestamp column stored normal date format, you can try to use summarize function to summary records by year month.
Summary table = SUMMARIZE ( ADDCOLUMNS ( Table, "Year Month", FORMAT ( Table[timestamp], "yyyy MM" ) ), "Year Month", [Year Month], "Product id", [product id], "Stock", [stock], "Summary QTY", SUM ( Table[qty] ) )
Then you can simply find out specific records by filter on 'year month'.
Regeards,
Xiaoxin Sheng
Hi @v-shex-msft,
Should I open a new table or can just add a new colume for the summarize?
Hi @natt,
'Summary table' is table formula, you can click on new table button to create a table to store this formula.
Regards,
Xiaoxin Sheng
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |