Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
amilajay369
New Member

Keep track of old data while updating

Hello all,

 

I am very new to Power Bi as well as for this group. 

 

I have Power BI report which need to show the status of KPI. The data file (Xlsx) is extracting from system and its replace the values in every week. For example for last week file : Project status = Inprogress and this week Project status = Completed.

 

Assume that I need to show weekly project staus count, and also I dont have the project close date in my file, that files contained only status.

Any method that have experianced in? Highly appriciate your time on this, Thank you. 

1 ACCEPTED SOLUTION
v-rzhou-msft
Community Support
Community Support

Hi @amilajay369 ,

 

As far as I know, Power BI is a read only application and it could only create visuals based on data model. So there should be data you need to help your calculation.

According to your statement, the data will be replaced every week. I think you need to keep all data you need instead of replacing. And then add date in your data source to determind the order of the data.

FX: Table should contain columns as [Date] /  [Status].

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
amilajay369
New Member

Thanks Rico, that is what I also thinking to do  now. Otherwise no option to save date. Thanks agin for your detailed explaianation. 

v-rzhou-msft
Community Support
Community Support

Hi @amilajay369 ,

 

As far as I know, Power BI is a read only application and it could only create visuals based on data model. So there should be data you need to help your calculation.

According to your statement, the data will be replaced every week. I think you need to keep all data you need instead of replacing. And then add date in your data source to determind the order of the data.

FX: Table should contain columns as [Date] /  [Status].

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!