I need help with this logic

Hi ajitsahoo8338 

Create a calculated column that checks each combination, sums their recorded hours, and returns the appropriate date. For example:

Result Date =
VAR CurrentProject = 'Table'[Project Name]
VAR CurrentActivity = 'Table'[Activity Number]
VAR CurrentTask = 'Table'[Task_Name]
VAR CurrentResource = 'Table'[Resource]

VAR TotalHours =
CALCULATE(
    SUM('Table'[Recorded_Hours]),
    FILTER(
        ALL('Table'),
        'Table'[Project Name] = CurrentProject &&
        'Table'[Activity Number] = CurrentActivity &&
        'Table'[Task_Name] = CurrentTask &&
        'Table'[Resource] = CurrentResource
    )
)

VAR LastHourDate =
CALCULATE(
    MAXX(
        FILTER(
            ALL('Table'),
            'Table'[Project Name] = CurrentProject &&
            'Table'[Activity Number] = CurrentActivity &&
            'Table'[Task_Name] = CurrentTask &&
            'Table'[Resource] = CurrentResource &&
            'Table'[Recorded_Hours] > 0
        ),
        'Table'[Date]
    )
)

RETURN
IF(
    TotalHours > 0,
    LastHourDate,
    'Table'[EndDate]
)

This column returns the last date with recorded hours if any exist, otherwise it returns the EndDate for that combination.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn|Twitter|Blog |YouTube