Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
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
Solved! Go to Solution.
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"
)
Perfect! I was definitely over complicating it. Thank you very much!!
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"
)
User | Count |
---|---|
56 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |