Sum rows corresponding to the same date and divide for number of days

[caseski]

Hi all,

I’m new to Power BI and above all I’m a novice in the use of powerQuery and dax and having no programming knowledge I cannot solve simple problems.

Now I'm trying to create a measure that allows you to sum values in the rows of a column corresponding to the same day and that divides by the number of days.

I try to explain myself better with a simplified table:

name	time	quantity
A	1/6/21 8.30	3,2
A	1/6/21 8.45	3,1
A	1/6/21 8.50	2,9
A	1/6/21 8.52	3,2
B	2/6/21 9.18	2,5
B	2/6/21 9.30	2,8
B	2/6/21 9.35	2,7
A	2/6/21 9.51	2,9
A	2/6/21 9.55	2,8
A	2/6/21 9.58	3,3

(time include also hours minutes and seconds)

The results is:

A = 21,4 / 2

Where:

21,4 = sum of quantity

2 = number of days

B = 8 / 1

I’d like also filter by months and name in order to visualize the total quantity for each name in every different month.

Thank you in advance

[Jihwan_Kim · Accepted solution]

Hi, @caseski 

I am not sure if I understood your question correctly, but please check the below picture and the sample pbix file's link down below.

Result Measure =

SUM ( 'Table'[quantity] ) / COUNTROWS ( VALUES ( 'Table'[Date] ) )

https://www.dropbox.com/s/jjpff0pw1llyy8w/caseski.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM