Measure needed using a date field

[wnicholl]

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

[ray_aramburo · Accepted solution]

Write a measure like this:

Date Count =
CALCULATE(COUNT('NameOfYourTable'[QORDT]), 'NameOfYourTable'[QORDT]) <> 0)

[wnicholl]

Hi Ray,

The measure worked great! Thanks very much for the quick reply! 

[ray_aramburo]

Glad it worked! Kindly mark it as solved for any future reference 🙂