Forum Discussion
Solved
Sumif based on colums
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
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 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.
Here is the sample data