Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
alexbalazsalex
Helper IV
Helper IV

Delta Calulation

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
1 ACCEPTED SOLUTION
alexbalazsalex
Helper IV
Helper IV

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

 

View solution in original post

3 REPLIES 3
alexbalazsalex
Helper IV
Helper IV

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

 

mangaus1111
Solution Sage
Solution Sage

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

alexbalazsalex
Helper IV
Helper IV

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.