Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
In excel it is used the function sumproducts, but in power bi there is no such function, how can I calculate the standard deviation?
Solved! Go to Solution.
Hi @vitexo87,
After research, you can use sumx function, I create the following example.
In Power BI, create a measure using the DAX.
result = SUMX(Table2,Table2[A]*Table2[B])
Create a card to diaply it, it return correct result as the following screenshot.
Best Regards,
Angelia
Hi @vitexo87,
After research, you can use sumx function, I create the following example.
In Power BI, create a measure using the DAX.
result = SUMX(Table2,Table2[A]*Table2[B])
Create a card to diaply it, it return correct result as the following screenshot.
Best Regards,
Angelia
https://msdn.microsoft.com/en-us/library/gg492207.aspx
Proud to be a Super User!
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |