count the days between 2 date columns for a given a name where time greater than 0

[Anonymous]

Below is the table i am working with and would like to get result on the last column 'count the days between columns '14 day' and 'saledate' for a given a name where time greater than 0'

SaleDate	Name	Time	14Day	count the days between 14 day and saledate and time greater than 0
1/11/2019	A	6.76		0
1/11/2019	B	6.76		0
1/14/2019	A	8.00		0
1/14/2019	B	8.00		0
1/15/2019	A	8.00		0
1/15/2019	B	8.00		0
1/16/2019	A	7.99		0
1/16/2019	B	7.99		0
1/17/2019	A	7.97		0
1/17/2019	B	7.97		0
1/18/2019	A	7.88		0
1/18/2019	B	7.88		0
1/21/2019	A	8.15		0
1/21/2019	B	8.15		0
1/22/2019	A	7.95		0
1/22/2019	B	7.95		0
1/23/2019	A	8.15		0
1/23/2019	B	8.15		0
1/24/2019	A	8.00		0
1/24/2019	B	8.00		0
1/25/2019	A	7.88	1/11/2019	11
1/25/2019	B	7.88	1/11/2019	11
1/28/2019	A	8.00	1/14/2019	11
1/28/2019	B	8.00	1/14/2019	11
1/29/2019	A	7.94	1/15/2019	11
1/29/2019	B	7.94	1/15/2019	11
1/30/2019	A	8.32	1/16/2019	11
1/30/2019	B	8.32	1/16/2019	11
1/31/2019	A	7.99	1/17/2019	11
1/31/2019	B	7.99	1/17/2019	11
2/1/2019	A	7.01	1/18/2019	11
2/1/2019	B	7.01	1/18/2019	11
2/4/2019	A	7.99	1/21/2019	11
2/4/2019	B	7.99	1/21/2019	11
2/5/2019	A	8.05	1/22/2019	11
2/5/2019	B	8.05	1/22/2019	11
2/6/2019	A	8.01	1/23/2019	11
2/6/2019	B	8.01	1/23/2019	11
2/7/2019	A	7.88	1/24/2019	11
2/7/2019	B	7.88	1/24/2019	11
2/9/2019	A	6.34	1/26/2019	10
2/9/2019	B	6.34	1/26/2019	10
2/11/2019	A	7.97	1/28/2019	11
2/11/2019	B	7.97	1/28/2019	11
2/12/2019	A	7.98	1/29/2019	11
2/12/2019	B	7.98	1/29/2019	11
2/13/2019	A	6.99	1/30/2019	11
2/13/2019	B	6.99	1/30/2019	11
2/14/2019	A	8.00	1/31/2019	10
2/14/2019	B	8.00	1/31/2019	10
2/15/2019	A	7.95	2/1/2019	11
2/15/2019	B	7.95	2/1/2019	11
2/18/2019	A	8.00	2/4/2019	11
2/18/2019	B	8.00	2/4/2019	11
2/19/2019	A	7.99	2/5/2019	11
2/19/2019	B	7.99	2/5/2019	11
2/20/2019	A	7.83	2/6/2019	11
2/20/2019	B	7.83	2/6/2019	11
2/21/2019	A	7.95	2/7/2019	11
2/21/2019	B	7.95	2/7/2019	11
2/22/2019	A	7.92	2/8/2019	11
2/22/2019	B	7.92	2/8/2019	11
2/25/2019	A	8.00	2/11/2019	11
2/25/2019	B	8.00	2/11/2019	11
2/26/2019	A	8.00	2/12/2019	11
2/26/2019	B	8.00	2/12/2019	11
2/27/2019	A	7.84	2/13/2019	11
2/27/2019	B	7.84	2/13/2019	11
2/28/2019	A	2.78	2/14/2019	11
2/28/2019	B	2.78	2/14/2019	11
3/1/2019	A	7.78	2/15/2019	11
3/1/2019	B	7.78	2/15/2019	11
3/4/2019	A	8.28	2/18/2019	11
3/4/2019	B	8.28	2/18/2019	11
3/5/2019	A	7.96	2/19/2019	11
3/5/2019	B	7.96	2/19/2019	11
3/6/2019	A	7.98	2/20/2019	11
3/6/2019	B	7.98	2/20/2019	11
3/7/2019	A	7.99	2/21/2019	11
3/7/2019	B	7.99	2/21/2019	11
3/9/2019	A	5.94	2/23/2019	11
3/9/2019	B	5.94	2/23/2019	11
3/11/2019	A	7.96	2/25/2019	11
3/11/2019	B	7.96	2/25/2019	11
3/12/2019	A	6.24	2/26/2019	11
3/12/2019	B	6.24	2/26/2019	11
3/13/2019	A	8.30	2/27/2019	11
3/13/2019	B	8.30	2/27/2019	11
3/14/2019	A	7.71	2/28/2019	11
3/14/2019	B	7.71	2/28/2019	11
3/15/2019	A	8.00	3/1/2019	11
3/15/2019	B	8.00	3/1/2019	11
3/17/2019	A	0.00	3/3/2019	10
3/17/2019	B	0.00	3/3/2019	10

Please help.

[Anonymous]

this is what i have so far..and it works as long as the time > 0.00...

CALCULATE(

COUNT(table[time]),

DATESBETWEEN(table[SaleDate],table[14Day],table[SaleDate]),

ALLEXCEPT(table,Table[Name]),table[Time] > 0.00

)

but if the time is 0.00 as for date 3/17 it doesn't get a value.

[Anonymous]

HI @Anonymous ,

So you means you also want to calculate records who has zero time value?
If this is a case, you can modify your condition to replace operator '>' to '>=' to calculate records who greater than or equal to zero.(Current condition will ignore formula calculate with zero value records)

Regards,

Xiaoxin Sheng