Pulling Data from one table into a SummarizedColumns Table

Hi Anonymous ,
Based on your description and the code provided, an attempt is being made to get the latest status from the SharePoint table based on the latest date, matching ID and job type. You could try separating the calculation of the latest date into a variable (LatestDate) and then use that variable to find the appropriate status, avoiding the use of switches to overdo the matching.

Latest SP Status Test =
VAR CID = CaseMaster[ID]
VAR WorkType = CaseMaster[WorkType]
VAR LatestDate = 
    CALCULATE(
        MAX(Sharepoint[Created Date]),
        FILTER(
            Sharepoint,
            Sharepoint[C ID] = CID &&
            (
                (WorkType = "WorkType 1" && Sharepoint[CaseType] = "CaseType 1") ||
                (WorkType = "WorkType 2" && Sharepoint[CaseType] = "CaseType 2") ||
                (WorkType = "WorkType 3" && (Sharepoint[CaseType] = "CaseType 3" || Sharepoint[CaseType] = "CaseType 4"))
            )
        )
    )
VAR WorktypeStatus = 
    CALCULATE(
        MAX(Sharepoint[CaseStatus]),
        FILTER(
            Sharepoint,
            Sharepoint[C ID] = CID &&
            Sharepoint[Created Date] = LatestDate &&
            (
                (WorkType = "WorkType 1" && Sharepoint[CaseType] = "CaseType 1") ||
                (WorkType = "WorkType 2" && Sharepoint[CaseType] = "CaseType 2") ||
                (WorkType = "WorkType 3" && (Sharepoint[CaseType] = "CaseType 3" || Sharepoint[CaseType] = "CaseType 4"))
            )
        )
    )
RETURN
IF(
    ISBLANK(WorktypeStatus),
    "Not Started",
    WorktypeStatus
)

Best regards,
Albert He

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