Create weekly data with 1 SharePoint List

[Mhalp11]

Hi all,

I have a SharePoint list, where every week, teammates would update the inventory level, by simply editing the value. Though i'm able to see the latest inventory value, but I'm trying to collect last week's inventory count and this week's inventory count.

e.g., looking to see 2 column weekcount 40, 39 , weekcount 41 with 35.

is there a way such that I can PowerBI can automatically collect data on a weekly basis?

thanks

[Mhalp11]

I don't have one yet, how would it be useful in my case?

[Dinesh_Suranga]

@Mhalp11 ,

If there is a calendar table it is easy to identify this week, start of this week , last week dates and last week start and end date.

Thanks.

[Dinesh_Suranga]

@Mhalp11 

Hi,

Yes it is possible in Power BI.

Do you have a calender or Date table in your data model?

Thank you.