topic Calculated column subtract values in DAX Commands and Tips

Calculated column subtract values

pfiloch — Thu, 09 Nov 2023 07:24:45 GMT

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

Re: Calculated column subtract values

FreemanZ — Thu, 09 Nov 2023 08:18:33 GMT

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:

Re: Calculated column subtract values

pfiloch — Thu, 09 Nov 2023 09:16:26 GMT

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

thx a lot

Re: Calculated column subtract values

FreemanZ — Fri, 10 Nov 2023 01:28:10 GMT

hi pfiloch ,

try out the proposal with your own dataset.

Re: Calculated column subtract values

Ashish_Mathur — Fri, 10 Nov 2023 02:57:10 GMT

Hi,

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