Calculate no dice roll

[ebercardoso1]

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
06/03/2021
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
15/03/2021
16/03/2021	100
17/03/2021	90
18/03/2021	10
19/03/2021	80
20/03/2021	70

[dedelman_clng]

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