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.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.