Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count from a specific data

Hi everyone, I need help to solve my problem... 😞   I got one Table with my item list (id and name) And I got one table with my datas about them : id, intervention_date, intervention_label 2  ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    You can use a calculate like this:

    CALCULATE(COUNT([FIELD]),[DATA_FIELD]>DATE(YEAR,MONTH,DAY),otherfilter)

     

    Let me know if this is what you were looking for.

     

    Best Regards,

    DR

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

You can use a calculate like this:

CALCULATE(COUNT([FIELD]),[DATA_FIELD]>DATE(YEAR,MONTH,DAY),otherfilter)

 

Let me know if this is what you were looking for.

 

Best Regards,

DR

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanx, sorry,

 

I used :

calculate(count('Fiches de maintenance'[Id]);'Fiches de maintenance'[Commentaires]="maintenance préventive 1";FILTER('Fiches de maintenance';'Fiches de maintenance'[Created]>calculate(max('Fiches de maintenance'[Created]);'Fiches de maintenance'[Commentaires]="maintenance préventive 2") && Outillages[Outillage]='Fiches de maintenance'[Piècedefectueuse]))
 
I always forget "FILTER()"