How to count cases with matching person-id's and other conditions

[MarcLykke]

Hi everyone

I am trying to count the number of cases with matching person-id's and several other conditions.

I have one table consisting of all the cases. Each person could have had several cases over time.

My mission is to calculate the total case length of each person - but only if the interval between the recent start date and the last end date is less than 1 year. 

Example below: 
The new column should reflect the total case length of each active case. There is less than a year between the start date of person 1's recent case and the last end date of the latest case. Therefore the total case length of this case is DATEDIFF(10/11-2020, TODAY).

In the case of person 2 on the other hand, there is more than a year between the recent start date and the latest end date. Therefore the total

I hope you guys can help me with this one.

Case id	Person id	Start date	End date	Status	Total case length (new)
1	1	10/11-2020	04/02-2021	Closed	DATEDIFF(10/11-2020, 04/02-2021)
2	1	05/05-2021		Active	DATEDIFF(10/11-2020, TODAY())
3	2	03/02-2019	05/10-2019	Closed	DATEDIFF(03/02-2019, 05/10-2019)
4	2	01/01-2021		Active	DATEDIFF(01/01-2021, TODAY())

[BeaBF]

@MarcLykke Hi!

You can calculate a column like this:

CASE = IF(Tabella[Status] = "Closed", DATEDIFF(Tabella[Start date], Tabella[End date], DAY), DATEDIFF(Tabella[Start date], TODAY(), DAY))

"DAY" in the DATEDIFF function, it can be any interval you want to calculate the difference, days, months, years.

I hope that's what you wanted, otherwise feel free to answer me.

B.

[ValtteriN · Accepted solution]

Hi, 

Here is one way to do this (I assume here you want do display the result in a visual).
Start data:

Calculated column:

Datediff_T = IF('Datediff'[Edate]=BLANK(),DATEDIFF('Datediff'[SDate],TODAY(),DAY),DATEDIFF('Datediff'[SDate],'Datediff'[Edate],DAY))

Filter measure: 

Datediff filter = IF(DATEDIFF(MAX('Datediff'[EDate]),MAX('Datediff'[Sdate]),DAY)<365,1,0)

End result (Here I placed the filter measure to filters):

I hope this helps to solve your issue and if it does consider accepting this as a solution!