Forum Discussion

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 03/02/2020 blabla

2 04/02/2020 maintenance1

3 06/02/2020 maintenance1

4 07/02/2020 blabla

2 10/02/2020 maintenance1

3 15/02/2020 maintenance2

...

And I would have this result :

item, nb maintenance1

1 5

2 3 (cause -> 5-2 "maintenance1")

3 5 (cause -> 5-0 "maintenance1" from the last "maintenance2")

4 5

I don't know if I'm clear...

Let me know!

Thanx for all!

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

3 Replies

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
  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()"
amitchandak
Super User
6 years ago
The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.