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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
dtet
New Member

creating and tracking sum of statuses

Hi, I might be completely lost on this and maybe I need to accomplish this outside of powerBI, and I am also very new to it. 

 

my dataset currently does not have a connection between the 'status' column and a date. the status column will change and update overtime (there is 4 status it can be in but only 2 are relevant to this). so I want to be able to know how many of each status existed on a given day. In my head it sounds like I need a table that I think on each data sync it would add a new row like so:

 

DateStatusCount
2021-07-13Development40
2021-07-14Development42
2021-07-14QA37
2021-07-15Development50
2021-07-15QA45
2021-07-16Development52
2021-07-16QA40

So this is the table of data Im interesting in seeing if I can create

 

My problem is once an item goes into a new status it stops getting counted on previous days, but the source data doesn't accurately track the dates this happens. So I guess I am attempting to track it in a simplified way

 

I hope this description makes some sense and I would appreciate any input on if this works or not and I can try to refine my details if anything seems unclear. Thank you.

1 ACCEPTED SOLUTION
fhill
Resident Rockstar
Resident Rockstar

Correct.  Unless you want to manually export something daily from PowerBI, to keep externally stored, and re-import the exported data as a new source (all manual).  Or manually add a data row by hand to an 'Insert Data' table (also all manual), no way to automate historical data that changed.




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




View solution in original post

3 REPLIES 3
dtet
New Member

So if Im understanding my scenario, I would need to pull the data from Azure DevOps, track with a different data source and load that new source back into powerBI? I can't insert data to a custom table within powerBI? Thanks

fhill
Resident Rockstar
Resident Rockstar

Correct.  Unless you want to manually export something daily from PowerBI, to keep externally stored, and re-import the exported data as a new source (all manual).  Or manually add a data row by hand to an 'Insert Data' table (also all manual), no way to automate historical data that changed.




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




fhill
Resident Rockstar
Resident Rockstar

Unfourtnately, Power BI does not maintain any history or on-going reporting.  Yes, as the live data updates all your data and measures will change.

 

 

 




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors