cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
natt Frequent Visitor
Frequent Visitor

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Is it possible to capture data at certain date?

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
5 REPLIES 5
domiowa Regular Visitor
Regular Visitor

Re: Is it possible to capture data at certain date?

How are your data?

Everything is in one table?

natt Frequent Visitor
Frequent Visitor

Re: Is it possible to capture data at certain date?

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

 

 

Community Support Team
Community Support Team

Re: Is it possible to capture data at certain date?

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
natt Frequent Visitor
Frequent Visitor

Re: Is it possible to capture data at certain date?

Hi @v-shex-msft,

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

Community Support Team
Community Support Team

Re: Is it possible to capture data at certain date?

Hi @natt,

 

'Summary table' is table formula, you can click on new table button to create a table to store this formula.

2.PNG

 

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |