If Function with dates measure then result but not giving accurate results

[PatelYU]

HI there,

I am using a function of 

Days =

IF ( (MAX('Maintenance Labour Utilisation'[Posting Date])) <= (MIN('Maintenance Details'[Basic Finish Date])), "On Time", "Late")

However, this fuction does not work completely. I have a posting date that is one day prior to basic finish date and it is showing on my table as LATE when in fact it is still on time. I do not understand this issue if someone can help me!

Below is my table. The left one shows the results of on time or late, and the right table is showing the posting dates of those work orders. As you can see all the selected work orders I am showing have a posting date of 28th October but in the column of 29th October those orders are showing as LATE when in fact they are not.

Thank you for your help!

[amitchandak]

@PatelYU , Can you share sample data and sample output in table format?

[PatelYU]

hi there,

sure. In excel i used the same formula i used in power bi.

IF= "basic finish date" <= "posting date", "on time", "late"

Work Orde Number	Basic Finish Date	Basic Start Date	posting date	Completed Not Completed
1400107211	31-Dec-19	08-Mar-19	21/01/2020	Late
1400119058	06-Apr-20	31-Mar-20	06/04/2020	On Time
1400119181	19-Sep-20	29-Nov-20	18/09/2020	On Time
1400118913	29-Dec-20	29-Nov-20	12/09/2020	On Time
1400119151	29-Dec-20	29-Nov-20	16/08/2020	On Time
1400119058	30-Apr-20	31-Mar-20	06/04/2020	On Time
1400119058	30-Apr-20	31-Mar-20	06/04/2020	On Time
1400119058	30-Apr-20	31-Mar-20	06/04/2020	On Time
1400119058	30-Apr-20	31-Mar-20	06/04/2020	On Time
1400119151	29-Jul-20	29-Nov-20	16/08/2020	Late
1400119151	29-Dec-20	29-Nov-20	16/08/2020	On Time
1400118913	29-Dec-20	29-Nov-20	12/09/2020	On Time
1400118913	29-Dec-20	29-Nov-20	12/09/2020	On Time
1400118913	29-Jun-20	29-Nov-20	12/09/2020	Late
1400119181	29-Dec-20	29-Nov-20	18/09/2020	On Time
1400119181	29-Dec-20	29-Nov-20	18/09/2020	On Time
1400119181	29-Dec-20	29-Nov-20	18/09/2020	On Time
1400119181	29-Dec-20	29-Nov-20	18/09/2020	On Time
1400119181	29-Dec-20	29-Nov-20	18/09/2020	On Time
1400119181	29-Dec-20	29-Nov-20	18/09/2020	On Time
1400119181	29-Dec-20	29-Nov-20	18/09/2020	On Time
1400119181	29-Dec-20	29-Nov-20	18/09/2020	On Time
1400119181	29-Dec-20	29-Nov-20	18/09/2020	On Time
1400119181	29-Dec-20	29-Nov-20	18/09/2020	On Time
1400119181	29-Dec-20	29-Nov-20	18/09/2020	On Time
1400119181	29-Dec-20	29-Nov-20	18/09/2020	On Time
1400119181	29-Dec-20	29-Nov-20	18/09/2020	On Time
1400119181	29-Dec-20	29-Nov-20	18/09/2020	On Time
1400119181	29-Dec-20	29-Nov-20	18/09/2020	On Time
1400119181	29-Dec-20	29-Nov-20	18/09/2020	On Time
1400119181	29-Dec-20	29-Nov-20	18/09/2020	On Time