The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 @Anonymous,
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