Forum Discussion

Dawn85's avatar
Dawn85
Frequent Visitor
5 years ago
Solved

Help with DAX IF AND expression OR a COUNTIF Measure

I am new to power BI so I am trying to figure out the best way to achieve the following: What I would like is a measure (a count) of which items are late being Quoted. I have 2 date columns; Da...
  • AlexisOlson's avatar
    AlexisOlson
    5 years ago

    You've got some mismatched parentheses.

     

    Does it work as expected when you fix that?

    LATE/ON TIME =
IF (
    AND (
        'winnipeg erp_workorder'[Date Received]
            < ( TODAY () - 5 ),
        ISBLANK ( 'winnipeg erp_workorder'[Date Quoted] )
    ),
    "LATE",
    "ON TIME"
)
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
5 years ago

You've got some mismatched parentheses.

 

Does it work as expected when you fix that?

LATE/ON TIME =
IF (
    AND (
        'winnipeg erp_workorder'[Date Received]
            < ( TODAY () - 5 ),
        ISBLANK ( 'winnipeg erp_workorder'[Date Quoted] )
    ),
    "LATE",
    "ON TIME"
)