Forum Discussion
Last Data Value and Count
| Event Activity | Event | Time | Target 1 | Target 2 |
| 1 | C | 1000 | 1000 | 0 |
| 1 | C | 1001 | 1001 | 0 |
| 1 | C | 1002 | 1002 | 3 |
| 1 | R | 1003 | 1002 | 0 |
| 1 | R | 1004 | 1002 | 0 |
| 1 | R | 1005 | 1002 | 0 |
| 1 | C | 1006 | 1006 | 0 |
| 1 | C | 1007 | 1007 | 2 |
| 1 | R | 1008 | 1007 | 0 |
| 1 | R | 1009 | 1007 | 0 |
Target 1: Whenever R comes, the value of the Time column is the previous value of C (like 1002)
Target 2: Count of R's value saved as the value of the previous C column.
Please help with this.
7 Replies
For Target 1
Target 1 = IF('Table'[Event] = "R", CALCULATE( MAX('Table'[Time]), FILTER('Table', 'Table'[Event] = "C" && 'Table'[Time] < EARLIER('Table'[Time])) ), 'Table'[Time] )Regards
Accept as a solution if it works.
