cancel
Showing results for 
Search instead for 
Did you mean: 
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!


I’ll be speaking at #MySummitNA this year.
Check out all the sessions, including mine here: https://hubs.ly/H0SXmgH0
I hope to see you in Houston October 12-15 #MySummitNA

Proud to be a Super User helping 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!


I’ll be speaking at #MySummitNA this year.
Check out all the sessions, including mine here: https://hubs.ly/H0SXmgH0
I hope to see you in Houston October 12-15 #MySummitNA

Proud to be a Super User helping give back to the community!
Thank You!




View solution in original post

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!


I’ll be speaking at #MySummitNA this year.
Check out all the sessions, including mine here: https://hubs.ly/H0SXmgH0
I hope to see you in Houston October 12-15 #MySummitNA

Proud to be a Super User helping give back to the community!
Thank You!




Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.