The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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...