Function to show repeated repaired tools

[Anonymous]

Hello,

I have a list with thousands of tools our company repaired. What I want to see is, the tools which are more than one time repiard and that in a short period.

I have one column with the serial number which is unique per tool, and the date when the tool arrived in our company to be repaired in the other column.

Is it possible to see for example the tool (or serial number) when it was repaired two times or more in one month?

I thought about a function which calculate the days between the dates, but I think this can´t work because the dates are in only one column...

Thanks in advance!

Christopher

[Anonymous]

can you please post some sample data, if you cannot share it then please make some dummy data that has the same issue

[Anonymous]

Hi Thomas,

here is some data I got from my report:

Equi Serial number	Creation date (inbound)
MASTERORDEREQUIPM	08.01.2016 07:57:22
D478061	08.07.2016 14:40:45
G5590320	26.09.2016 12:55:50
D8383433	05.09.2016 20:23:09
D478061	05.09.2016 20:30:21
C661230 C661230	19.09.2016 15:57:29 30.09.2016 15:57:29

When it is there to be repaired, you can see the serial number twice. What I want to see is, when the same tool (same serial number) is more than one time in our workshop in for example one month.

Is there a function to show that?

[Anonymous · Accepted solution]

There are a few ways you could do this.

The simplest one is to use the following measure

Count = 
VAR RowCount =
    COUNTROWS ( Table1 )
RETURN
    IF ( RowCount > 1, RowCount, BLANK () )

then just have a table with the part column and this measure. Then add a date slicer and any parts that have more than one occurrence will show in the table.

If you want to do it in a measure it can depend on the final context for this use.