Forum Discussion
Calculation between consecutive rows in dynamic table
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,
3 Replies
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-Forum/ba-p/963216
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/1447523Batch 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
