Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |