Calculated column subtract values

[pfiloch]

Dear all,

i want to have a calculated coulmn called diff. Here i want to substract the value for each Cat -100 (actually the value from Car OEE100. But can be also use a constant if easier.

Like Cat="" Availability" 69.5340... - 100 and write the result in column diff.

Next Cat = "Performance" 62.192... - 100

Thx to all

[Ashish_Mathur]

Hi,

Share data in a format that can be pasted in an MS Excel file.

[pfiloch]

Thx for the reply. But for row 2 i need value -38 since 62-100 is the substraction.

thx a lot

[FreemanZ]

hi @pfiloch ,

try out the proposal with your own dataset. 

[FreemanZ]

hi @pfiloch ,

try to add a column like:

column = 
VAR _valuepre =
MAXX(
    TOPN(
        1,    
        FILTER(data, data[Index]<EARLIER(data[index])), 
        data[index]
    ),    
    data[value]
)
RETURN
[Value] - _valuepre

it worked like: