Forum Discussion
Calculate the previous data
Hello Team , I want to calculate the previous data before the time period id date status 1 1-May open 1 30-Apr closed ...
Can you please be more specific? It's not entirely clear what you want to achieve. Thanks.
I want to count of Id's of Previous date where latest status is open and the slicer is changing
Condition 1:
Slicer
| 3-May | 14-Jul |
i need the data before 3 May
Condition 2:
| 4-Jul | 14-Jul |
Need data before 4 july
| d | date | status | |||||||||
| 1 | 1-May | open | |||||||||
| 1 | 30-Apr | closed | |||||||||
| 1 | 2-May | open | |||||||||
| 1 | 4-Jul | closed |