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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
kattlees
Post Patron
Post Patron

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?

1 REPLY 1
Greg_Deckler
Super User
Super User

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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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