Forum Discussion

bouyazbekj's avatar
bouyazbekj
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 o...
Need Help
  • Anonymous's avatar
    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

Anonymous's avatar
Anonymous
Not applicable
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

bouyazbekj's avatar
bouyazbekj
Helper I
6 years ago

Hello Anonymous  

Thanks a lot!!!