Forum Discussion
Count Cases based on Days between Dates
Trying to figure out the best way to do this.
I want to create a measure wheere I can Distinct Count cases where the FIRST Date of Request to Recieved Date is 15 days or less, as we can request items multiple times before we get them.
In the example below, Case 1 and 2 would be counted since the first request was 15 days or less. So my value would be 2. Case 3 had its first request 28 days before we got it and 4 was 19 days. The other dates do not matter, just the first.
Anonymous
you can try to create a new column
Column = if('Table'[request date]=CALCULATE(min('Table'[request date]),ALLEXCEPT('Table','Table'[case id]))&&'Table'[Days Difference]<=15,1,0)then you sum up the new column and you will get 2
see attached
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
3 Replies
Anonymous
you can try to create a new column
Column = if('Table'[request date]=CALCULATE(min('Table'[request date]),ALLEXCEPT('Table','Table'[case id]))&&'Table'[Days Difference]<=15,1,0)then you sum up the new column and you will get 2
see attached
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.