Hi guys, please help here. I am getting the Dax comparison operations do not support comparing value

[Wayne_Swiss]

CF Gantt =

VAR StartDate =

    CALCULATE ( MIN ( v_ProjectGantt[ProjectStartDate] ), REMOVEFILTERS ( 'Date' ) )

VAR EndDate =

    CALCULATE ( MIN ( v_ProjectGantt[ProjectEndDate] ), REMOVEFILTERS ( 'Date' ) )

VAR ProjectPeriod =

    MIN ( 'Date'[Date] ) >= StartDate

        && MIN ( 'Date'[Date] ) <= EndDate

VAR ProjectStatus =

    CALCULATE ( MIN ( v_ProjectGantt[CompletionStatus] ), REMOVEFILTERS ( 'Date' ) )

VAR Result =

    SWITCH (

        TRUE (),

        ProjectPeriod

            && ProjectStatus = "Completed", 1,

        ProjectPeriod

            && ProjectStatus = "Delayed", 2,

        ProjectPeriod

            && ProjectStatus = "Open", 3

    )

RETURN

    Result

[PaulDBrown · Accepted solution]

The issue is ProjectPeriod.

Try:

CF Gantt =
VAR StartDate =
    CALCULATE ( MIN ( v_ProjectGantt[ProjectStartDate] ), REMOVEFILTERS ( 'Date' ) )
VAR EndDate =
    CALCULATE ( MIN ( v_ProjectGantt[ProjectEndDate] ), REMOVEFILTERS ( 'Date' ) )
VAR ProjectPeriod =
    FILTER (
        VALUES ( 'Date'[Date] ),
        MIN ( 'Date'[Date] ) >= StartDate
            && MIN ( 'Date'[Date] ) <= EndDate
    )
VAR ProjectStatus =
    CALCULATE ( MIN ( v_ProjectGantt[CompletionStatus] ), REMOVEFILTERS ( 'Date' ) )
VAR Result =
    SWITCH (
        TRUE (),
        MAX ( Date[Date] )
            IN ProjectPeriod
            && ProjectStatus = "Completed", 1,
        MAX ( Date[Date] )
            IN ProjectPeriod
            && ProjectStatus = "Delayed", 2,
        MAX ( Date[Date] )
            IN ProjectPeriod
            && ProjectStatus = "Open", 3
    )
RETURN
    Result