Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |