Delta Calulation

[alexbalazsalex]

Dears,

I created a smal table with Inv Real / Bdg Real / Delta

than i used to following formula to populate the matrix :

Price Per table2 =

IF (

HASONEVALUE ( 'Index per inv/bdg'[Inv Bdb] ),

SWITCH (

VALUES ( 'Index per inv/bdg'[Inv Bdb] ),

"INV 22/23", [Price US$/TN],

"BDG 22/23", [Price Bdg US$/TN],

"Delta", [Price US$/TN]-[Price Bdg US$/TN]

),

0

)

THe Real and Bdg Price works fine but the delta is not showing anything

I suppose i need to use a calculate function to calculate this part ?

Any support will be highly apreciated

Alex

[alexbalazsalex · Accepted solution]

Figured out the issue by myself, the formlas started workign after cutting the relationship between the 2 tables.

[mangaus1111]

Sorry, having trouble following, can you post sample data as text and expected output?

[alexbalazsalex]

Just to add this is how the table looks like Inv Bdb

Inv Bdb

Inv 22/23

Bdg 22/23

Delta

And this is linked to a database and the price has the following formula

Price US$/TN = divide(sum(Invoicing),sum(tons))

THanks