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 h...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    9 years ago

    rahulshewale1,

     

    You just need to add a measure as shown below.

    Measure =
CALCULATE ( DISTINCTCOUNT ( Table1[Date] ) )
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] ) )