topic SUMPRODUCT in Power BI in DAX Commands and Tips

SUMPRODUCT in Power BI

Edmundas — Thu, 18 May 2023 10:53:16 GMT

Hi,

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?

Re: SUMPRODUCT in Power BI

Anonymous — Fri, 19 May 2023 03:04:05 GMT

Hi Edmundas ,

Please try this:

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

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data in the Power BI Forum

Re: SUMPRODUCT in Power BI

Edmundas — Fri, 19 May 2023 06:31:53 GMT

Awesome, it worked perfect. Thank you so much.