Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Wayne_Swiss
New Member

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

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
1 ACCEPTED SOLUTION
PaulDBrown
Community Champion
Community Champion

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




Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

1 REPLY 1
PaulDBrown
Community Champion
Community Champion

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




Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.