Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I need to calculate the standard deviation of a population made of monthly part sales (quantities). Each row gives the historic consumption (from 1 month in the past - Cons_1Month - to 12 months in the past - Cons_12Months ) of a part number - ITEMID.
I need the std.dev, for every rows (each p/n), of the population made of columns "Cons_1Month" to "Cons_12Months"
I prefer not to transpose as I have several other pieces of information I need to keep for each PN.
I found only ways to calculate std.dev per columns. Any idea ?
Thank you !
AC
Hi, @ACU
If the following methods didn't solve your problem. Can you provide a PBIX file that is available for testing? What do you expect the results to look like that can be shown in an example Excel chart. I look forward to hearing from you.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
You could do the unpivot operation to a calculated table and use that new table with RELATED to calculate standard deviation to your original table.
Example DAX (add ID to its own column in the UNION):
Proud to be a Super User!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
31 | |
14 | |
12 | |
10 | |
10 |