Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
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
Thanx, sorry,
I used :
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |