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.
Dear friends,
I have a table with percentage data posted daily, this data is automatically generated by a sharepoint list, however, when I average the launches in the month, it does not calculate the days when there was no launch, which I should calculate with the note 0,
Any idea how to do this?
01/03/2021 | 100 |
02/03/2021 | 90 |
03/03/2021 | 10 |
04/03/2021 | 80 |
05/03/2021 | 70 |
| |
07/03/2021 | 50 |
08/03/2021 | 30 |
09/03/2021 | 40 |
10/03/2021 | 100 |
11/03/2021 | 90 |
12/03/2021 | 10 |
13/03/2021 | 80 |
14/03/2021 | 70 |
| |
16/03/2021 | 100 |
17/03/2021 | 90 |
18/03/2021 | 10 |
19/03/2021 | 80 |
20/03/2021 | 70 |
Hi @ebercardoso1 -
You will need a Calendar/Date table for this to work correctly. CALENDAR() or CALENDARAUTO() can create date tables if you do not have one already. Once your Date table is created, you create a 1-to-many relationship from the Date table, Date field, to your data table, date field.
You can then calculate the average over the deisred period with:
AvgPosted =
DIVIDE (
SUM ( Launches[Pct Posted] ),
COUNTROWS ( ALLSELECTED ( DateCalendar[Date] ) ),
0
)
Hope this helps
David
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 |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |