Forum Discussion

rahulshewale1's avatar
rahulshewale1
New Member
9 years ago
Solved

Distinct Count within start date and end date

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

2 Replies

  • rahulshewale1's avatar
    rahulshewale1
    New Member
    9 years ago
     

    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's avatar
      v-chuncz-msft
      Community Support
      9 years ago

      rahulshewale1,

       

      You just need to add a measure as shown below.

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