Forum Discussion
Solved
Sumifs in Calculated Column
Good day I am wanting to sum the the columns from two table into a new column in a third table. I have to make sure that it only sums the data matching in both tables from two other columns. Theref...
o this is variable to store the fields values. After you can use it as criteria in a measure
HI
Please find the code
Total =
var matos='Final IAS TEE'[Material]
var STP='Final IAS TEE'[Sold to Pary]
var amtIAS=LOOKUPVALUE(IAS[Month],'Final IAS TEE'[Material],matos,IAS[Sold to Pary],STP)
var amtTEE=LOOKUPVALUE(TEE[Month],'Final IAS TEE'[Material],matos,IAS[Sold to Pary],STP)
var result=amtIAS+amtTEE
return
result
Thank you for your response.
I am very very new to power bi and so have a few questions if you dont mind.
have new tables been created for these two steps:
var matos='Final IAS TEE'[Material]
var STP='Final IAS TEE'[Sold to Pary]
thank you