Forum Discussion
Solved
Measure needed using a date field
Hello,
I have a date field that contains dates and "0". I need to create a measure that will count the dates but exclude the "0".
Any help would be appriciated and thanks in advance!!
Here is a sample of my date field for reference. So the total count should 6.
| QORDT |
| 20220101 |
| 20230515 |
| 0 |
| 0 |
| 20210822 |
| 20230516 |
| 20230518 |
| 20210510 |
| 0 |
Regards,
Bill
Write a measure like this:
Date Count = CALCULATE(COUNT('NameOfYourTable'[QORDT]), 'NameOfYourTable'[QORDT]) <> 0)
3 Replies
Write a measure like this:
Date Count = CALCULATE(COUNT('NameOfYourTable'[QORDT]), 'NameOfYourTable'[QORDT]) <> 0)Hi Ray,
The measure worked great! Thanks very much for the quick reply!
Glad it worked! Kindly mark it as solved for any future reference 🙂
