Count from a specific data

[Anonymous]

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!

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Anonymous · Accepted solution]

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]

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()"