SUMPRODUCT equivalent in Power BI

[Edmund]

Hi there,

I have data table of three columns and need fourth column with results as it is shown in picture (column D). Tried lookupvalue, sumx but I don't have enough skills to do what I need. Any help please?

 

[Edmund]

Hi there, I got two decisions to this quest:

(1)

Result =
Var ThisDate = [Date]
Var ThisRegion = [Region]
Return
SUMX(FILTER(table, table[Date]=ThisDate && table[Region]=ThisRegion),
table[Ratio])

(2)

Result =
SUMX(
FILTER(
ALL('Table'),
'Table'[Date] =EARLIER ('Table'[Date])
&& 'Table'[Region] = EARLIER('Table'[Region])),
'Table'[Ratio])