Forum Discussion
Function to show repeated repaired tools
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
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.
3 Replies
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?
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.