Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello folks,
I have this below excel function where i need to have dax to it in power bi, how can it be written?
=SUMPRODUCT(G2:G16,$F2:$F16)/SUMIF(G2:G16,">0",$F2:$F16)
G = Tier
F= Product weight
Thanks
shekar
Hi @kxj54590 ,
The SUMX function will allow you to sum things across tables.It may like SUMPRODUCT in Excel.
You could try to create a measure like this:
Measure =
var sum_p = CALCULATE(SUMX(Sheet1,Sheet1[Units Sold]*Sheet1[Sale Price]))
var sum_if = CALCULATE(SUM(Sheet1[Sale Price]),FILTER(ALL(Sheet1),Sheet1[Units Sold]<1000))
return DIVIDE(sum_p,sum_if,0)
You can also refer to these thread:
https://community.powerbi.com/t5/Desktop/Sumproduct-formula-in-PowerBI/m-p/696519
https://community.powerbi.com/t5/Power-Query/Sumproduct-with-Power-Query/td-p/1012427
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@kxj54590 it will be easier if you throw sample data with the expected output.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
User | Count |
---|---|
93 | |
83 | |
77 | |
70 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |