excel formula to power bi

[pro_x]

Hi,

How do i write this excel formula to power bi:

sumproduct(r4:r36;x4:x36)/sum(x4:x36)

[Greg_Deckler]

@pro_x - The DAX equivalent for SUMPRODUCT is found here:

https://community.powerbi.com/t5/Community-Blog/S-Excel-to-DAX-Translation/ba-p/1061121

SUMPRODUCT = 
    VAR __Table = 
        ADDCOLUMNS(
            'Table1',
            "Value",[Value1] * RELATED(Table2[Value2])
        )
RETURN
    SUMX(__Table,[Value])

[pro_x]

Thanx but how would i write that formula?