Verildi

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).

Beceriler: Muhasebe, Veri İşleme, Excel, Matematik, İstatistik

Daha fazlasını gör: 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, sql server power bi R, \ power bi\ , microsoft power BI, 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

İşveren Hakkında:
( 3 değerlendirme ) Birmingham, United States

Proje NO: #15845595

Bu iş için 2 freelancer ortalamada $21 teklif veriyor

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(8 Değerlendirme)
3.0
kgiridhari

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(6 Değerlendirme)
2.3