Forum Discussion
Standard Deviation from Varying Starting Points
Hello PBI Enthusiasts,
Kudos to anyone who can help or at least get me in the right direction. I have a set of data that I want to calculate the standard deviation starting only in the first month of sales for a given product / region combination. In another query, I found the first month of sales (St Dev Lookup Min Month) and then I merged queries using it as a reference column. I would also want to include any zeroes that occurred after the first month of sales. Thank you so much in advance. If my desired outcome is not clear, please let me know.
BTW, I apologize for the screenshot. I can't seem to paste the actual data in an acceptable HTML format
2 Replies
You can always try to paste it in Excel then paste back here. Or perform text recognition. Help others to help you. Otherwise who ever wants to help needs to type your data manually.
Hi Jakinta, here is the text:
Product Region Calendar Year/Month Sales St Dev Lookup.Min Month Desired Outcome
Pencils EMEA 4/1/2022 2833 4/1/2022 The standard deviation of Pencils / EMEA beginning 4/1/2022
Pencils EMEA 12/1/2022 4190 4/1/2022 The standard deviation of Pencils / EMEA beginning 4/1/2022
Pens EMEA 10/1/2022 5539 10/1/2022 The standard deviation of Pens / EMEA beginning 10/1/2022
Pens EMEA 2/1/2023 3698 10/1/2022 The standard deviation of Pens / EMEA beginning 10/1/2022
Pens EMEA 12/1/2022 4062 10/1/2022 The standard deviation of Pens / EMEA beginning 10/1/2022
Pencils NAFTA 10/1/2022 7814 4/1/2021 The standard deviation of Pencils / NAFTA beginning 4/1/2021
Pencils NAFTA 4/1/2021 9760 4/1/2021 The standard deviation of Pencils / NAFTA beginning 4/1/2021
Pencils NAFTA 12/1/2022 4808 4/1/2021 The standard deviation of Pencils / NAFTA beginning 4/1/2021
