Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
79 | |
61 | |
60 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |