topic Re: Comparing Date Diff between Two Date fields but need to know if Met OnTime in DAX Commands and Tips

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

Anonymous — Tue, 03 Nov 2020 21:42:57 GMT

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

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

edhans — Tue, 03 Nov 2020 23:03:47 GMT

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

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

amitchandak — Wed, 04 Nov 2020 02:56:46 GMT

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"

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

Anonymous — Wed, 04 Nov 2020 17:48:11 GMT

Thank you!