Forum Discussion

patpois's avatar
patpois
Regular Visitor
2 years ago
Solved

Count a column containing repeating date with time

Hi   I'm trying to count resolved incidents by month. The data contains date with hour. Note that in the same day, you can have in the same hour multiple entries (2023-12-04 15:15:50 & 2023-12-04 1...
  • patpois's avatar
    patpois
    2 years ago

    Hi

     

    Here what i did to fix my issue.

    I change the data column from Date/Time to Date in the data value (Edit Query) since I don't care about the time and just want the date count.

     

    So, here is the measure that I created and is functionnal for my needs:

     

    Incident Resolved Monthly = COUNTROWS(FILTER('BBD Incidents',[Resolved]>=MIN('Date'[Date])&&[Resolved]<=MAX('Date'[Date])&&NOT(ISBLANK([Resolved]))))
     
    Thanks you all for your help !
    Have i nice day
patpois's avatar
patpois
Regular Visitor
2 years ago

Hi

 

Here what i did to fix my issue.

I change the data column from Date/Time to Date in the data value (Edit Query) since I don't care about the time and just want the date count.

 

So, here is the measure that I created and is functionnal for my needs:

 

Incident Resolved Monthly = COUNTROWS(FILTER('BBD Incidents',[Resolved]>=MIN('Date'[Date])&&[Resolved]<=MAX('Date'[Date])&&NOT(ISBLANK([Resolved]))))
 
Thanks you all for your help !
Have i nice day