How can I get the timestamp for each error transaction in the report

[gauravnarchal]

I have a table below. I wanted the timestamp of each transaction when it first got displayed in a table.

Basically my purpose is to display or track the error through the timestamp when the error was first reported or shown in the report. It is not a data refresh date instead of when the error was first displayed in the report.

Not sure if this is possible, but any help would be appreciated.

[Anonymous · Accepted solution]

HI @gauravnarchal 

If you don't have the date in your data set then it is not possible to display the first reported date as when the report is pulled from the source.

The dataset when refreshed doesn't know which is the new records in comparison of the old report. It calculates its measures and calculated columns based on the pulled dataset everytime.

So, it is not possible.

[amitchandak]

@gauravnarchal , Can you share sample data and sample output in table format?

[gauravnarchal]

@amitchandak Please find below more information

1. Sample data as text, use the table tool in the editing bar

Client Invoice Status

ABC	1227	Delivered
ABC	1228	Delivered
ABC	1229	Delivered
ABC	1230
ABC	1235	Delivered
BAT	1225
BAT	1226
CAB	1221	Delivered
CAB	1222	Delivered
CAB	1223	Delivered
CAB	1224	Delivered
FIX	1231
FIX	1232	Delivered
FIX	1233	Delivered
FIX	1234
SIT	1236
SIT	1237	Delivered
SIT	1238	Delivered
SIT	1239	Delivered

2. Expected output from sample data

3. Explanation in words of how to get from 1. to 2.

My purpose is to track the error through the date stamp when it was first reported or for how long this error is not being resolved. Any transaction with no status is an error.

Not sure if this is possible. Thank You for your help.

[Greg_Deckler]

@gauravnarchal - Where are the dates coming from?

[Greg_Deckler]

@gauravnarchal - Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[gauravnarchal]

@Greg_Deckler  Please find below more information

1. Sample data as text, use the table tool in the editing bar

Client Invoice Status

ABC	1227	Delivered
ABC	1228	Delivered
ABC	1229	Delivered
ABC	1230
ABC	1235	Delivered
BAT	1225
BAT	1226
CAB	1221	Delivered
CAB	1222	Delivered
CAB	1223	Delivered
CAB	1224	Delivered
FIX	1231
FIX	1232	Delivered
FIX	1233	Delivered
FIX	1234
SIT	1236
SIT	1237	Delivered
SIT	1238	Delivered
SIT	1239	Delivered

2. Expected output from sample data

3. Explanation in words of how to get from 1. to 2.

My purpose is to track the error through the date stamp when it was first reported or for how long this error is not being resolved. Any transaction with no status is an error.

Not sure if this is possible. Thank You for your help.