Rolling sum optimization

[AGo]

Hello,

I populated a line chart with a cumulative function:

Rolling count = SUMX(FILTER(ALLSELECTED(Tab[timestamp]),Tab[timestamp]<=MAX(Tab[timestamp])),CALCULATE(SUM(Tab[DeltaWithPreviousRowValue]),Tab[Item]="Console1", Tab[Sensor]="Counters/Cuts"))

For each record I calculated the column [DeltaWithPreviousRowValue], I've got also the [value] which is a event incremental counter.

I can't use time hiearchy on my axis because I need to prompt the line automatically in hours if few days are selected, and days if a long time range is selected in the date filter.

Maybe a function that subtracts always the [Value] at start time and not using [DeltaWithPreviousRowValue] can work fine? In this case I have no idea how to fix pre-calculated MIN(Tab[value]) as a variable/sort of parameter.

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!

[sturlaws]

Hi @AGo 

I don't get what your issue is. Could you create a sample report and share it?

Cheers,
Sturla

[amitchandak]

@AGo , a New column like

maxx(filter(Table, table[timestamp] <earlier(table[timestamp] )),table[timestamp]) -table[timestamp]

[AGo]

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.