Forum Discussion

Mhalp11's avatar
Mhalp11
New Member
3 years ago

Create weekly data with 1 SharePoint List

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

 

 

Need Help

3 Replies

  • Dinesh_Suranga's avatar
    Dinesh_Suranga
    Continued Contributor
    3 years ago

    Mhalp11 

    Hi,

    Yes it is possible in Power BI.

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

    Thank you.

  • Mhalp11's avatar
    Mhalp11
    New Member
    3 years ago

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

     

    • Dinesh_Suranga's avatar
      Dinesh_Suranga
      Continued Contributor
      3 years ago

      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.