Comparing Date Diff between Two Date fields but need to know if Met OnTime

[lisastrand]

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

[amitchandak · Accepted solution]

@lisastrand , 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"

[lisastrand]

Thank you!

[edhans]

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