Sumif based on colums

[sureshgowda666]

Hello Team,

Need help in having the sum if in the conditional colum based on the 2 colums

Note, in the table i have more than 50 colums

[Anonymous · Accepted solution]

Hi @sureshgowda666 

You can refer to the following example.

Create the calculated column.

Sum = SUMX(FILTER('Table',[ID]=EARLIER('Table'[ID])),[USD Value])

You can refer to the following example to know more about sumx() function

SUMX – DAX Guide

SUMX Power BI | How to use SUMX Function in Power BI? (with Example) (wallstreetmojo.com)

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sureshgowda666]

Here is the sample data

 

[AbbasG]

@sureshgowda666 if you can share some sample data with the desired outcome, it will be helpful to guide you.