Calculation between consecutive rows in dynamic table

[Tsarka119]

Hi Power BI Community,

I hope that you'll bring me solutions to the problem that I've been stucking with for a few days. I couldn't find a solution in similar subjects.

I have a facts table that lists personnel events for a company that has multiple departments. So for one event there is the reference, one date and the name of the personne involved with its department.

I would like to obtain in a dynamic measure (not a calculated column) the maximum value based on the difference between the date in row and the previous one(sorted by ascending date), and that whatever the department selected in a slicer. (The first event can't have a value)

See the example in Excel :

I can get the result for all the table but not for filtered context

Thanks for your help.

Regards,

[Ashish_Mathur · Accepted solution]

Hi,

You may download my solution workbook from here.

Hope this helps.

[AmilAmarasekara]

Batch Number	Shrinkage L	Shrinkage W
CL65500	-3	3.6.
CJ63520	-3.2	-3
CH63500	-2	-5.6.
CK56200	3	--2.6
CT85600	5	-5.9
CJ65200	-3.2	-6.3
FG56233	--2.6	-3.6
GH53620	--0.3	-2.6
VG45632	3	-2.3.
GT89600	-3.6	--3.8
CG59000	-2.9.	-3
BG65300	-5	5
VH45000	-2.8.	9
	it has two  " - " mark
	it has two " . " mark

during enter data by oporotor, came this issue. this table had error two "-" and "." so how can remove from the table please give solution

[lbendlin]

Read about the windowing functions, specifically OFFSET.

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...