Need help for a matrix

[Toine51]

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

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...