Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear Power BI community
What do I want to achieve?
I am looking for some assistance to help create a DAX expression so I can filter across 2 different tables
1. 'Dim date table'[DaysFromToday]
2. 'Dim time table'[HourOfDay]
So I can show what?
I want to get the average number of discharges at the same point in time (Current hour) over the last 4 weeks
For example. On average there were 15 discharges on a Friday for the last 4 weeks between 12pm-1pm
How is my data structured
My data is structured so that I can get a count of discharges for every day and fo every hour of day
SumOfDischargeCount | DaysFromToday | HourOfDay |
6 | -28 | 0 |
6 | -28 | 3 |
5 | -28 | 5 |
6 | -28 | 6 |
8 | -28 | 7 |
5 | -28 | 8 |
6 | -28 | 9 |
18 | -28 | 10 |
14 | -28 | 11 |
13 | -28 | 12 |
17 | -28 | 13 |
20 | -28 | 14 |
24 | -28 | 15 |
27 | -28 | 16 |
31 | -28 | 17 |
31 | -28 | 18 |
20 | -28 | 19 |
26 | -28 | 20 |
11 | -28 | 21 |
10 | -28 | 22 |
7 | -28 | 23 |
So far my DAX looks like this:
Think I have solved my own issue
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |