DateDiff Errors

[Anonymous]

Hello

Trying to calculate the amount of days between 2 date columns. Tried DateDiff but receiving an error. 

I want to see if Drawings Approved is within 2 weeks of Drawings Submitted. And then from there visualize the outliers. 

Step 1 was to count the days between the two columns.

CCTV Days bt ReviewApproved = DATEDIFF(MIN( 'Current Master List'[CCTV Drawings Approved by Brand (Date) ].[Date]), MAX( 'Current Master List'[CCTV Drawings Submitted to Brand (Date)].[Date], day ) ) 

I receive the error that too few arguments are happening, although it's the same as the formula online but updated with my columns.

Note: not all fields are completed and there many blanks- maybe this is causing it to error?

[ChrisMendoza · Accepted solution]

@Anonymous,

Unfortunately I wasn't able to reproduce your error.

Using my sample data:

ApprovedDate	SubmittedDate
7/1/2018	7/2/2018
7/1/2018	7/3/2018
7/1/2018	7/4/2018
7/1/2018	7/5/2018
7/1/2018	7/6/2018
7/1/2018	7/7/2018
7/1/2018	7/8/2018
7/1/2018	7/9/2018
7/1/2018	7/10/2018
7/1/2018	7/11/2018
7/1/2018	7/12/2018
7/1/2018	7/13/2018
7/1/2018	7/14/2018
7/1/2018	7/15/2018
7/1/2018	7/16/2018
7/1/2018	7/17/2018
7/1/2018	7/18/2018
7/1/2018	7/19/2018
7/1/2018	7/20/2018
7/1/2018	7/21/2018
7/1/2018	7/22/2018
7/1/2018	7/23/2018
7/1/2018	7/24/2018
7/1/2018	7/25/2018
7/1/2018	7/26/2018
7/1/2018	7/27/2018
7/1/2018	7/28/2018
7/1/2018	7/29/2018
7/1/2018	7/30/2018
7/1/2018	7/31/2018

I created the following Calculated Columns:

Column = DATEDIFF(Table1[ApprovedDate],Table1[SubmittedDate],DAY)

Column 2 = DATEDIFF(MIN(Table1[ApprovedDate]),MAX(Table1[SubmittedDate]),DAY)

Column 3 = 
IF(
   DATEDIFF(Table1[ApprovedDate],Table1[SubmittedDate],DAY) <= 14,
   TRUE(),
   FALSE()
) 

Which produced the following:

I believe what you're after is something like what exists in [Column 3] correct?