Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ebercardoso1
New Member

Calculate no dice roll

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/2021100
02/03/202190
03/03/202110
04/03/202180
05/03/202170
  • 06/03/2021
 
07/03/202150
08/03/202130
09/03/202140
10/03/2021100
11/03/202190
12/03/202110
13/03/202180
14/03/202170
  • 15/03/2021
 
16/03/2021100
17/03/202190
18/03/202110
19/03/202180
20/03/202170
1 REPLY 1
dedelman_clng
Community Champion
Community Champion

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
)

 

2021-03-18 08_26_43-scratch4 - Power BI Desktop.png

Hope this helps

David

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.