cancel
Showing results for
Did you mean:
Frequent Visitor

## 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

1 ACCEPTED SOLUTION
Super User IV

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

Proud to be a Super User!

3 REPLIES 3
Super User IV

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

Proud to be a Super User!

Frequent Visitor

Thank you!

Super User III

Please provide some sample data with expected results.

How to provide sample data in the Power BI Forum

Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting

Announcements