Forum Discussion
Comparing Date Diff between Two Date fields but need to know if Met OnTime
Comparing Date Diff between Two Date fields to determine if my team is meeting expectations OnTime.
I have determined the duration between the dates but need to know:
- Is the Close Date Month (field/column) is =/> Expiration Date Month (field/column)
If YES - KPI Met (OnTime)
If No - KPI Met (not OnTIme and how many months are we behind)
I just can't seem to figure out this formula.
Thanks!
Lisa
Anonymous , You can have new columns like
KPI Status = if([Close Date Month] >=[Expiration Date Month],"KPI Met (OnTime)", " KPI Met (not OnTIme)")
Diff when not met = if([Close Date Month] >=[Expiration Date Month],blank() , datediff([Close Date Month],[Expiration Date Month],day))
or one combined
combined = if([Close Date Month] >=[Expiration Date Month],"KPI Met (OnTime)", " KPI Met (not OnTIme) ") & if([Close Date Month] >=[Expiration Date Month],blank() , datediff([Close Date Month],[Expiration Date Month],day)) & " months behind"
3 Replies
- amitchandak
Super User
Anonymous , You can have new columns like
KPI Status = if([Close Date Month] >=[Expiration Date Month],"KPI Met (OnTime)", " KPI Met (not OnTIme)")
Diff when not met = if([Close Date Month] >=[Expiration Date Month],blank() , datediff([Close Date Month],[Expiration Date Month],day))
or one combined
combined = if([Close Date Month] >=[Expiration Date Month],"KPI Met (OnTime)", " KPI Met (not OnTIme) ") & if([Close Date Month] >=[Expiration Date Month],blank() , datediff([Close Date Month],[Expiration Date Month],day)) & " months behind" - edhans
Community Champion
Please provide some sample data with expected results.
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum
