FieldValue in variables

[suzel404]

Hi all,

I have a complex situation to realize.

I have a straight table with range / Start / End / StartEnd / Measure

When I select the range StartEnd I can see Previous StartEnd and Forward StartEnd.

For Example I select StartEnd 10000 - 20000

I get Previous StartEnd 8500-10000

and Forward StartEnd : 20000-30000.

When I do vary my slicer with vStart and vEnd, I would like in straight table :

STARTEND     START    END

8500-10000     8500         vStart

10000-20000   vStart        vEnd

20000-30000   vEnd         30000

So, If I put Distance field, I can see distance and profitability vary between the range StartEnd above and below.

Thank for your help.

[suzel404]

Updated data.

[suzel404 · Accepted solution]

I use avg and Aggr function.