Hello everyone, I'm trying to count the number of days on a job for a specific client. In the following table for example the number of days is 6 total. Each day has multiple tickets . Any idea of how to acheive this? I'm happy with a "card" for visualization. YearMonthDayTicketNumberBusinessPartnerName2019August138775Encana Corporation2019August138776Encana Corporation2019August139547Encana Corporation2019August139548Encana Corporation2019August238797Encana Corporation2019August238798Encana Corporation2019August239574Encana Corporation2019August239575Encana Corporation2019August338829Encana Corporation2019August338830Encana Corporation2019August339600Encana Corporation2019August339601Encana Corporation2019August438875Encana Corporation2019August438876Encana Corporation2019August439630Encana Corporation2019August439631Encana Corporation2019August538903Encana Corporation2019August538929Encana Corporation2019August539667Encana Corporation2019August539668Encana Corporation2019August639681Encana Corporation2019August639703Encana Corporation2019August639704Encana Corporation2019August639713Encana Corporation2019August639714Encana Corporation

Helper I

6 years ago

Solved

Count based on days

Hello everyone,

I'm trying to count the number of days on a job for a specific client. In the following table for example the number of days is 6 total. Each day has multiple tickets . Any idea of how to acheive this? I'm happy with a "card" for visualization.

Year	Month	Day	TicketNumber	BusinessPartnerName
2019	August	1	38775	Encana Corporation
2019	August	1	38776	Encana Corporation
2019	August	1	39547	Encana Corporation
2019	August	1	39548	Encana Corporation
2019	August	2	38797	Encana Corporation
2019	August	2	38798	Encana Corporation
2019	August	2	39574	Encana Corporation
2019	August	2	39575	Encana Corporation
2019	August	3	38829	Encana Corporation
2019	August	3	38830	Encana Corporation
2019	August	3	39600	Encana Corporation
2019	August	3	39601	Encana Corporation
2019	August	4	38875	Encana Corporation
2019	August	4	38876	Encana Corporation
2019	August	4	39630	Encana Corporation
2019	August	4	39631	Encana Corporation
2019	August	5	38903	Encana Corporation
2019	August	5	38929	Encana Corporation
2019	August	5	39667	Encana Corporation
2019	August	5	39668	Encana Corporation
2019	August	6	39681	Encana Corporation
2019	August	6	39703	Encana Corporation
2019	August	6	39704	Encana Corporation
2019	August	6	39713	Encana Corporation
2019	August	6	39714	Encana Corporation

Need Help

Anonymous

6 years ago

HI bouyazbekj

You can try the following measure:

_Count_M =
VAR _TEMP =
    GROUPBY ( T27, T27[Day], T27[Month], T27[Year] )
VAR _COUNT =    
     COUNTROWS ( _TEMP )
RETURN
    _COUNT

Forum Discussion

Count based on days

3 Replies

Related content

Counting nulls

Day Count Measure

Count base from other column

Count Operating Days

Count per day