Help with DAX IF AND expression OR a COUNTIF Measure

Question

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; Date Received and Date Quoted.

1st idea:

I created a column with the following DAX expression:

Code:

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

that I was hoping would flag which items were late and which were on time, but it was clearly written incorrectly.

What I wanted was:

If the date received was greater than 5 days prior to todays date AND Date Quoted is blank, mark as "LATE", otherwise it is "ON TIME".

I then want to create a measure that counts anything that is listed as "LATE".

2nd idea:

Perhaps the count could be done without creating the extra column and do a measure that counts the row If the date received was greater than 5 days prior to todays date AND Date Quoted is blank.

I hope someone can help me, still trying to learn DAX.

Thank you

alexisolson · Accepted Answer

You've got some mismatched parentheses.&nbsp;Does it work as expected when you fix that?LATE/ON TIME =
IF (
    AND (
        'winnipeg erp_workorder'[Date Received]
            &lt; ( TODAY () - 5 ),
        ISBLANK ( 'winnipeg erp_workorder'[Date Quoted] )
    ),
    "LATE",
    "ON TIME"
)

Forum Discussion

Help with DAX IF AND expression OR a COUNTIF Measure

2 Replies

Related content

COUNTIF measure

Index Countif

Measure - Countif <= Date

Help!!! Expression Error

Regular expression