Forum Discussion

Toine51's avatar
Toine51
Regular Visitor
3 years ago

Need help for a matrix

Hello everyone,

I need some help.

I've managed to get that :

this is the average of occurencies for each hour during a long period of time.

I got this with the measure : 

Moyenne = 
COUNT(Data[Heure])/CALCULATE(DISTINCTCOUNT(Data[Date]),ALL(Data[Heure]))

 

Now I would like to create a matrix, with a double entry :

in row : start time

in column : end start

and the values would be the sum of the average. So that for example, if I have in row : 20:00:00, and in column : 03:00:00, my value would be the sum of the averages of 20h, 21h, 22h, 23h, 00h, 01h and 02h.

 

It would give the whole matrix something like that.

 

Thank you very much for yyour help,

BR

Antoine