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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
rijal1371
New Member

Need help to express math calculation in a DAX formula

Hello, I am quite new at Power BI, and recently I'm stuck at how to write a math calculation in DAX.

I have a table that contains the values needed to be calculated ("IFault value" (If) column), and what I want to achieve is to add a new column next to it, which will contain the result "t" :

 

rijal1371_0-1649901757607.png

the rest of variables needed for the formula are stored in another table:

rijal1371_1-1649902030463.png

and this is the math equation:

rijal1371_3-1649902368840.png

Final result that I wanted to achieve is "t" columns for each parameter.

 

Any help will be greatly appreciated, thank you!

 

2 REPLIES 2
amitchandak
Super User
Super User

@rijal1371 , How can we get the value from another table, relationship between two table to exchange data ?

 

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

@amitchandak , thank you for replying. I'll watch your videos first, its really helpful at giving some insights. As for my current model, they don't have any proper relationship established yet, so I might need to tweak it a little bit more. I'll mention you later when I'm stuck again.

Once again, thank you so much for the help! 😊

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.