Forum Discussion
Simple multiplication with quick measure?
Hi, I am going crazy?! 3 secs in Excel, 2 hrs in PowerBI...... I am simply trying to multiply 1 column by a percentage value from another column, using the quick measure button.... I have tried u...
camargos88
Community Champion
Community ChampionHi Anonymous ,
If those tables are related, use the SUMX function.
Hi, I just hit a wall with this? I though max was the usual one too.....
- camargos88
Anonymous ,
SUMX(TABLE, COLUMN X COLUMN)
- amitchandak
Super User
Anonymous , You need have common group by or dimension where you can group this data and multiply
Like
Sumx(summarize(Dimension,Dimension[Dim],"_1",sum(MergeData[EAC]) , "_2",sum(BasecaseRpiX[Percent Indextaion])),[_1]*[_2])
Refer, how I have taken advantage order dim to take date diff
