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

[JoshP11]

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!

[amitchandak · Accepted solution]

@JoshP11 , A measure like this should work

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