Showing results for 
Search instead for 
Did you mean: 
kattlees Member

Total Count with Missing Information

I have a weird question - I pull data from a program that holds all of our guest data.

I have a column that finds errors in time entries so a report can be pulled so they get fixed and it can total the # of errors

Column is this: Time Error = if (endtime < starttime),1,0


The next day, the corrections are downloaded and the error is gone. 


The problem is the error count goes down after the error is fixed. We do not have a date field that I can compare against and do not have the ability to add one.


What I would like to do is keep a total of how many errors there are in a given day/month so we can work on reducing that number.


Is there a way to keep a row marked as had error so I can get an accurate count of how many errors there were even after it has changed?

Super User
Super User

Re: Total Count with Missing Information

What I would look at in your case would be to have a PowerApp tied to a SharePoint list or database or something and put that in your report. You could use that to enter the errors for the day and store it in your SharePoint list or database as a row. Then you could just pull that additional data source into your report.

I have book! Learn Power BI from Packt

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 46 members 942 guests
Please welcome our newest community members: