Standard Deviation from varying starting points

[krisplikj]

Hello Power BI enthusiasts,

Hoping someone can help here.  I have a data set that I need to calculate the stanard deviation for each row.  The catch is, I need the calculate it from the first "non zero" cell moving from left to right.  (or I could reorder the data points from right to left, if easier).  So, the first row would start on column 35, row 2 would start at column 36, row 3 at column 32, and so on.  It makes no difference if the best solution is simply by adding columns or DAX.

Many thanks in advance for any ideas and / or support.  Thanks!

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[krisplikj · Accepted solution]

Hi Ibendlin, thanks for the advice,  I'm going to close this thread and start a new one with the sample data in the correct format.  Best Regards.

[krisplikj]

Hello again,

When I've posted in the past, I would normally get a solution relatively quickly.  Since this has not happened yet, I'm guessing with the way I presented the question below, a solution is not possible.  That said, I am rephrasing the question in a way that I believe there is a solution based off other questions I've seen solved.

So in the previous screenshot, I had converted the dates into number of months from the current month and pivoted the data.  Here I have an unpivoted table where in another query, I found the min month of "non zeroes" by region and then merged queries with this one.  The "calendar year / month" column has 36 Months of data points while the "St Dev Lookup. Min Month" references the first "non-zero" month that occurred.  Can anyone tell me how to do a standard deviation on the "Test" Column where it only starts counting at the "St Dev Lookup.Min Month" occurrence?  And by the way, I do want to include any zeroes that occurred after the Min Month.  Kudos to anyone that can help and thanks again in advance!