Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I populated a line chart with a cumulative function:
timestamp | Item | Sensor | value | Rank | DeltaWithPreviousRowValue |
11/06/2020 17:04:12 | Console1 | Counters/Cuts | 2416 | 1003 | 1 |
11/06/2020 17:04:07 | Console1 | Counters/Cuts | 2415 | 1002 | 1 |
11/06/2020 17:04:01 | Console1 | Counters/Cuts | 2414 | 1001 | 1 |
11/06/2020 17:03:56 | Console1 | Counters/Cuts | 2413 | 1000 | 1 |
11/06/2020 17:03:50 | Console1 | Counters/Cuts | 2412 | 999 | 1 |
11/06/2020 17:03:45 | Console1 | Counters/Cuts | 2411 | 998 | 1 |
11/06/2020 17:03:35 | Console1 | Counters/Cuts | 2410 | 997 | 1 |
11/06/2020 17:03:14 | Console1 | Counters/Cuts | 2409 | 996 | 1 |
11/06/2020 17:02:53 | Console1 | Counters/Cuts | 2408 | 995 | 1 |
11/06/2020 17:02:35 | Console1 | Counters/Cuts | 2407 | 994 | 1 |
11/06/2020 17:02:27 | Console1 | Counters/Cuts | 2406 | 993 | 1 |
11/06/2020 17:02:22 | Console1 | Counters/Cuts | 2405 | 992 | 1 |
11/06/2020 17:02:18 | Console1 | Counters/Cuts | 2404 | 991 | 1 |
11/06/2020 17:02:15 | Console1 | Counters/Cuts | 2403 | 990 | 2 |
11/06/2020 17:02:09 | Console1 | Counters/Cuts | 2401 | 989 | 1 |
11/06/2020 17:02:05 | Console1 | Counters/Cuts | 2400 | 988 | 2 |
11/06/2020 17:01:59 | Console1 | Counters/Cuts | 2398 | 987 | 1 |
11/06/2020 17:01:56 | Console1 | Counters/Cuts | 2397 | 986 | 2 |
11/06/2020 17:01:50 | Console1 | Counters/Cuts | 2395 | 985 | 2 |
11/06/2020 17:01:44 | Console1 | Counters/Cuts | 2393 | 984 | 1 |
11/06/2020 17:01:40 | Console1 | Counters/Cuts | 2392 | 983 | 2 |
11/06/2020 17:01:34 | Console1 | Counters/Cuts | 2390 | 982 | 1 |
11/06/2020 17:01:31 | Console1 | Counters/Cuts | 2389 | 981 | 2 |
11/06/2020 17:01:25 | Console1 | Counters/Cuts | 2387 | 980 | 2 |
11/06/2020 17:01:19 | Console1 | Counters/Cuts | 2385 | 979 | 1 |
11/06/2020 17:01:15 | Console1 | Counters/Cuts | 2384 | 978 | 2 |
11/06/2020 17:01:09 | Console1 | Counters/Cuts | 2382 | 977 | 1 |
11/06/2020 17:01:06 | Console1 | Counters/Cuts | 2381 | 976 | 2 |
11/06/2020 17:01:00 | Console1 | Counters/Cuts | 2379 | 975 | 2 |
11/06/2020 17:00:54 | Console1 | Counters/Cuts | 2377 | 974 | 1 |
Many thanks in advance!
Hi @AGo
I don't get what your issue is. Could you create a sample report and share it?
Cheers,
Sturla
@AGo , a New column like
maxx(filter(Table, table[timestamp] <earlier(table[timestamp] )),table[timestamp]) -table[timestamp]
No, I'm sorry, the resulting value I need in my measure is not from timestamp column, it has to be extracted from calculations based on [vaue] or [DeltaWithPreviousRowValue] depending on which one is easier to use.
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |