willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 921
- Office Version
- 365
- Platform
- Windows
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:
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
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
