Forum Discussion
Is it possible to capture data at certain date?
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!
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
5 Replies
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
