Group time

[wil2803]

Hi community,

I have the following scenario

ID	System	company	start_date	finish_date
1	AAAA	XPTO	22/07/2021 08:30	22/07/2021 10:15
2	BBBB	XPTO B	22/07/2021 11:30	23/07/2021 11:30
3	CCCC	XPTO C	22/07/2021 11:30	23/07/2021 11:34
4	DDDD	XPTO D	23/07/2021 08:45	23/07/2021 11:30

I need to create a metric that only considers ids 1 and 3, as the time of ids 2 and 4 are contained within the period of id 3.
It's possible?

[Anonymous]

How to Get Your Question Answered Quickly - Microsoft Power BI Community