Distinct Count within start date and end date

[rahulshewale1]

Dear sir,

how to use formula Countif with between two date?

example: Jack buy product at 01-01-17 with two time, first time is 1000, second time is 200, so show me total is 1200.so no matter how many time Jack buy at same day, also count for 1 time. if i choose date 01-01-17 to 05-01-17, Jack at 01-01-17 Three time to come buy product , 02-01-17 1 time to come buy product, 03-01-17 1 time to come buy product, 04-01-17 1 time to come buy product, 05-01-17 1 time to come buy product,so Total Jack is come to my shop for 5 time only.

Regard

rahul shewale

[rahulshewale1]

Dear sir,

how to use formula Countif with between two date?

example: Jack buy product at 01-01-17 with two time, first time is 1000, second time is 200, so show me total is 1200.so no matter how many time Jack buy at same day, also count for 1 time. if i choose date 01-01-17 to 05-01-17, Jack at 01-01-17 Three time to come buy product , 02-01-17 1 time to come buy product, 03-01-17 1 time to come buy product, 04-01-17 1 time to come buy product, 05-01-17 1 time to come buy product,so Total Jack is come to my shop for 5 time only.

Regard

rahul

Rahul shewale

[v-chuncz-msft · Accepted solution]

@rahulshewale1,

You just need to add a measure as shown below.

Measure =
CALCULATE ( DISTINCTCOUNT ( Table1[Date] ) )