show me a DAX formula for Power BI

I need to replicate excel's sumproduct function using the DAX language in Power BI. I have attached a simple excel spreadsheet with two tabs of input data as well as the output tab I need to recreate using Power BI instead of excel. In this example, each portfolio has a % allocation to multiple strategies and each strategy has a % allocation to multiple holdings. I need to get the holdings % by portfolio (strategy weight * holding weight).

Taidot: kirjanpito, tietojenkäsittely, Excel, Matematiikka, Tilastotiede

Näytä lisää: sql server power bi R, \ power bi\ , microsoft power BI, power bi measure vs column, power bi sumx, power bi calculated field, power bi dax functions, power bi calculate function, power bi formulas, power bi measure if statement, power bi calculated measure, We are a technology company which specializes in Hardware (i.e Electronic Gadgets and sensors). , excel power bi, power bi freelance, informatico freelance power bi excel, i.e.p. direct, i&e designer job netherlands, freelance power bi, desenvolvedor freelancer power bi microsoft, c.i.e. tours

Tietoa työnantajasta:
( 3 arvostelua ) Birmingham, United States

Projektin tunnus: #15845595

2 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

$25 USD 1 päivässä
(8 arvostelua)

A proposal has not yet been provided

$17 USD 1 päivässä
(6 arvostelua)