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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
JoshP11
Helper I
Helper I

Create measure to get a total from defined dates, then divide by total of weeks within the dates

Hello! 

 

I'm fairly new to using PBI and hoping someone might know a simple solution to my qeuery!

 

I want to create a measure for a visual to get me the 'Total Minutes' from my Table, for dates between 01/01/2021 and 01/05/2022 in the Table, and then divide the value of the 'Total Minutes' found by the total number of weeks within those dates, rounded down.

 

- There will be a slicer to select the Name(s) I want to display

- The X axis will contain Name

- The Y axis will contain the measure I need creating

 

So then as a example of how it should work, for Name - 'Joe Blogg'

 

- the Total Minutes between 01/01/2021 and 01/05/2022 = 2966

- then the total number of weeks between those dates equals 43

- then 2966 / 43 = 68.97

 

I've tried a measure to get the total of minutes and then another measure to divide that value by 43 however it doesn't seem to work!

 

Any help would be appreciated 🙂

 

Any help would be appreciated!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@JoshP11 , A measure like this should work

 

divide(sum(Table[Total Minutes]), 43)

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@JoshP11 , A measure like this should work

 

divide(sum(Table[Total Minutes]), 43)

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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