Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Find Overlapping Dates Records

Hello All,   I am newbie to powerbi and i need your guide and suggestions.   I have a sample data as below.   Task       Resource    Start           End  Task 1 Resource 1 02-Jul-19 ...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • camargos88's avatar
    camargos88
    6 years ago

    Hi Anonymous ,

     

    Try this code:

     

    Overlapping =
    VAR _start = 'Table'[Start]
    VAR _end = 'Table'[ End ]
    VAR _result = COUNTROWS(
    FILTER(
    'Table',
    'Table'[Task ] = EARLIER('Table'[Task ]) &&
    'Table'[Resource ] = EARLIER('Table'[Resource ]) &&
    (
    (_start >= 'Table'[Start] && _start <= 'Table'[ End ])
    )
    ))
    RETURN _result - 1
     
     
     
camargos88's avatar
camargos88
Community Champion
6 years ago

Hi Anonymous ,

 

Try this code:

 

Overlapping =
VAR _start = 'Table'[Start]
VAR _end = 'Table'[ End ]
VAR _result = COUNTROWS(
FILTER(
'Table',
'Table'[Task ] = EARLIER('Table'[Task ]) &&
'Table'[Resource ] = EARLIER('Table'[Resource ]) &&
(
(_start >= 'Table'[Start] && _start <= 'Table'[ End ])
)
))
RETURN _result - 1