Forum Discussion
Solved
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...
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 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
