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.
I am a novice to Power BI, and Dax. I could not find an example, or question related to my challenge. I have a series of test as follows:
Test 1, date, time, value
Test 1, date, time, value
Test 1, date, time, value
Test 1, date, time, value
Test 2, date, time, value
Test 2, date, time, value
Test 2, date, time, value
Test 2, date, time, value
Test 3, date, time, value
Test 3, date, time, value
Test 3, date, time, value
Test 3, date, time, value
Test 3, date, time, value
Test 3, date, time, value
Test 3, date, time, value
Test 3, date, time, value
I want to graph the lapse time in hours from FIRSTDATE [date],[time] to LASTDATE [date],[time] of each test set, and then while using a single graph, plot each hour for each test, showing a comparison overtime to itself, as well as to the other test sets.
The first entry for each test set (Test 1, Test 2, Test 3) would have a lapse time of ZERO hours, as this entry is the starting point, the subsequencial entries would caculate the lapse time between the starting point, and the current entry date/time.
I just cannot seem to an example or similiar question that demos my outcome.
@sport wrote:I am a novice to Power BI, and Dax. I could not find an example, or question related to my challenge. I have a series of test as follows:
Test 1, date, time, value
Test 1, date, time, value
Test 1, date, time, value
Test 1, date, time, value
Test 2, date, time, value
Test 2, date, time, value
Test 2, date, time, value
Test 2, date, time, value
Test 3, date, time, value
Test 3, date, time, value
Test 3, date, time, value
Test 3, date, time, value
Test 3, date, time, value
Test 3, date, time, value
Test 3, date, time, value
Test 3, date, time, value
I want to graph the lapse time in hours from FIRSTDATE [date],[time] to LASTDATE [date],[time] of each test set, and then while using a single graph, plot each hour for each test, showing a comparison overtime to itself, as well as to the other test sets.
The first entry for each test set (Test 1, Test 2, Test 3) would have a lapse time of ZERO hours, as this entry is the starting point, the subsequencial entries would caculate the lapse time between the starting point, and the current entry date/time.
I just cannot seem to an example or similiar question that demos my outcome.
I used 2 calculated columns:
TestTime = length of each test
_CumulativeTestTime = cumulative sum of the individual test entries by Test set
Use DateDiff to measure the time change
_CumulativeTestDuration =
DATEDIFF (
CALCULATE (
MIN ( 'TestResults'[Date Time] ),
FILTER (
'TestResults',
'TestResults'[TestID] = EARLIER ( 'TestResults'[TestID] )
)
),
'TestResults'[Date Time],
HOUR
)
End Visualization
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 |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |