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!! ...
Write a measure like this:
Date Count = CALCULATE(COUNT('NameOfYourTable'[QORDT]), 'NameOfYourTable'[QORDT]) <> 0)
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 🙂