Forum Discussion
SUMIF in PowerBI?
So I have two data sets - one named data and one named plan. I need to create a column in the plan dataset that pulls in information from the data dataset. There is a column called "Line" in both dat...
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous,
There must be a relationship between these two tables. I guess the table "Plan" is in the 1-side. You could try this formula. The "relatedtable" will find out all the related data and sumx will sum the [Total amount] up.
Column = SUMX ( RELATEDTABLE ( Data ), [TotalAmount] )
Best Regards!
Dale