Forum Discussion
Multiply 2 columns from 2 different tables
Hi Team, I'm new in Power BI and i've been struggling doing few things. My only teachers are videos and forums online, I can't seem to crack this one thing. I have 2 columns from 2 tables whi...
Hi v-yulgu-msft,
There are 3 tables which are Related to reflect the Shortage Column.
This relationship allows to dynamically show the Shortage and Unit Prices based on month.
What I would like achieve is to have a calculation of the Total Amount (USD) based on the quantity in Shortage Column and Unit Price column.
Overdeployment Table
Since the storage column is from another table, try to use RELATED function and see if it works
Total Amount='TableName'[Unit Price]*RELATED('TableName'[Storage])