Is it possible to capture data at certain date?

[natt]

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!

[domiowa]

How are your data?

Everything is in one table?

[natt]

@domiowa
I have only one table showing every stock change.
product id, qty, stock, timestamp

[v-shex-msft · Accepted 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

[natt]

Hi @v-shex-msft,

Should I open a new table or can just add a new colume for the summarize? 

[v-shex-msft]

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