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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.