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.

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