Forum Discussion
power query/ dax measure , multiple conditions/ multiple answers
I have loaded multiple tables in power query table of revenue per category: category revenue EM01 86.000 EM02 68.000 EM03 ...
Here is a formula approach if table are loaded to sheet.
=PIVOTBY(D2:D12,E2:E12,XLOOKUP(D2:D12,A2:A9,B2:B9)*F2:F12,SUM,0,0)