Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Sales_operation
Regular Visitor

Distinct count of a value one time a day and increment

‎11-18-2019 05:01 AM

Dears

I Want to count (distinct) each item one (1) time on a day (no matter it's repeating on the same day) and increment the count with 1 if it exists on another day and so on...

 

DateINVOICE_NUMBERCust CodeITEM ID   
07-07-19N_0170401212Item1 Item12
07-07-19N_0170401212Item1 Item22
07-07-19N_0170401212Item1 Item32
07-07-19N_0170401212Item6 Item41
24-07-19N_0178351212Item1 Item51
24-07-19N_0178351212Item1 Item62
24-07-19N_0178351212Item2   
24-07-19N_0178351212Item2   
24-07-19N_0178351212Item2   
24-07-19N_0178351212Item3   
24-07-19N_0178351212Item4   
24-07-19N_0178351212Item4   
24-07-19N_0178351212Item6   
27-07-19N_0179811212Item2   
27-07-19N_0179811212Item2   
27-07-19N_0179811212Item3   
27-07-19N_0179811212Item5   
Message 1 of 1
506 Views
0
0 REPLIES 0

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All