Calculated column subtract values

Question

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&nbsp;Thx to all

freemanz · Answer

hi&nbsp;pfiloch&nbsp;,
&nbsp;
try to add a column like:
column = 
VAR _valuepre =
MAXX(
    TOPN(
        1,    
        FILTER(data, data[Index]&lt;EARLIER(data[index])), 
        data[index]
    ),    
    data[value]
)
RETURN
[Value] - _valuepre
&nbsp;
it worked like:

&nbsp;

pfiloch · Answer

Thx for the reply. But for row 2 i need value -38 since 62-100 is the substraction.&nbsp;thx a lot

freemanz · Answer

hi&nbsp;pfiloch&nbsp;,
&nbsp;
try out the proposal with your own dataset.&nbsp;

ashish_mathur · Answer

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

Forum Discussion

Calculated column subtract values

4 Replies

Related content

Subtraction calulation

TMDL - calculated column

Subtracting Measure from Calculated Column

Subtract two columns

Subtract one month from date column