Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
wnicholl
Resolver II
Resolver II

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

  

1 ACCEPTED SOLUTION
ray_aramburo
Super User
Super User

Write a measure like this:

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

 





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





View solution in original post

3 REPLIES 3
ray_aramburo
Super User
Super User

Write a measure like this:

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

 





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





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 🙂 





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.