topic Re: Standard Deviation and Averaging in Developer https://community.fabric.microsoft.com/t5/Developer/Standard-Deviation-and-Averaging/m-p/1929545#M30228 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/309793">@j4ymastah</a>&nbsp;</P> <P>You can add a YearMonth column in your data model. Then you can achieve your goal by measure or calculate funtion in Table visual directly.</P> <P>Add a YearMonth column.</P> <LI-CODE lang="markup">YearMonth = FORMAT('Table'[LOGIN DATE - Copy],"YYYYMM")</LI-CODE> <P>Measure:</P> <LI-CODE lang="markup">SD Per Month = CALCULATE(STDEV.P('Table'[Count]),FILTER(ALL('Table'),'Table'[YearMonth]=MAX('Table'[YearMonth])))</LI-CODE><LI-CODE lang="markup">AVG Per Month = CALCULATE(AVERAGE('Table'[Count]),FILTER(ALL('Table'),'Table'[YearMonth]=MAX('Table'[YearMonth])))</LI-CODE> <P>Or use Average/S<SPAN>tandard Deviation function in table visual.</SPAN></P> <P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1.png" style="width: 213px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/543665i4A4184D348D32592/image-dimensions/213x606?v=v2" width="213" height="606" role="button" title="1.png" alt="1.png" /></span></SPAN></P> <P>Result is as below.</P> <P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2.png" style="width: 730px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/543667i7EF3254660C73502/image-size/large?v=v2&amp;px=999" role="button" title="2.png" alt="2.png" /></span></SPAN></P> <P><SPAN>Best Regards,</SPAN></P> <P><SPAN>Rico Zhou</SPAN></P> <P>&nbsp;</P> <P>If this post <STRONG>helps</STRONG>, then please consider <EM><STRONG>Accept it as the solution</STRONG></EM> to help the other members find it more quickly.&nbsp;</P> <P>&nbsp;</P> Wed, 30 Jun 2021 03:11:27 GMT Anonymous 2021-06-30T03:11:27Z Standard Deviation and Averaging https://community.fabric.microsoft.com/t5/Developer/Standard-Deviation-and-Averaging/m-p/1925528#M30207 <P>Good day.</P><P>&nbsp;</P><P>I am trying to get the standard deviation (SD) and average (AVE) of the following data:</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>LOGIN DATE - Copy <TABLE><TBODY><TR><TD>Jan 01 2021</TD></TR><TR><TD>Jan 04 2021</TD></TR><TR><TD>Jan 02 2021</TD></TR><TR><TD>Jan 05 2021</TD></TR><TR><TD>Jan 03 2021</TD></TR><TR><TD>Jan 06 2021</TD></TR><TR><TD>Jan 07 2021</TD></TR><TR><TD>Jan 08 2021</TD></TR><TR><TD>Jan 09 2021</TD></TR><TR><TD>Jan 10 2021</TD></TR><TR><TD>Jan 11 2021</TD></TR><TR><TD>Jan 12 2021</TD></TR><TR><TD>Jan 13 2021</TD></TR><TR><TD>Jan 14 2021</TD></TR><TR><TD>Jan 15 2021</TD></TR><TR><TD>Jan 16 2021</TD></TR><TR><TD>Jan 17 2021</TD></TR><TR><TD>Jan 18 2021</TD></TR><TR><TD>Jan 19 2021</TD></TR><TR><TD>Jan 20 2021</TD></TR><TR><TD>Jan 21 2021</TD></TR><TR><TD>Jan 22 2021</TD></TR><TR><TD>Jan 23 2021</TD></TR><TR><TD>Jan 24 2021</TD></TR><TR><TD>Jan 25 2021</TD></TR><TR><TD>Jan 26 2021</TD></TR><TR><TD>Jan 27 2021</TD></TR><TR><TD>Jan 28 2021</TD></TR><TR><TD>Jan 29 2021</TD></TR><TR><TD>Jan 30 2021</TD></TR><TR><TD>Jan 31 2021</TD></TR><TR><TD>Feb 01 2021</TD></TR><TR><TD>Feb 02 2021</TD></TR><TR><TD>Feb 03 2021</TD></TR><TR><TD>Feb 04 2021</TD></TR><TR><TD>Feb 05 2021</TD></TR><TR><TD>Feb 06 2021</TD></TR><TR><TD>Feb 07 2021</TD></TR><TR><TD>Feb 08 2021</TD></TR><TR><TD>Feb 09 2021</TD></TR><TR><TD>Feb 10 2021</TD></TR><TR><TD>Feb 11 2021</TD></TR><TR><TD>Feb 12 2021</TD></TR><TR><TD>Feb 13 2021</TD></TR><TR><TD>Feb 14 2021</TD></TR><TR><TD>Feb 15 2021</TD></TR><TR><TD>Feb 16 2021</TD></TR><TR><TD>Feb 17 2021</TD></TR><TR><TD>Feb 18 2021</TD></TR><TR><TD>Feb 19 2021</TD></TR><TR><TD>Feb 20 2021</TD></TR><TR><TD>Feb 21 2021</TD></TR><TR><TD>Feb 22 2021</TD></TR><TR><TD>Feb 23 2021</TD></TR><TR><TD>Feb 24 2021</TD></TR><TR><TD>Feb 25 2021</TD></TR><TR><TD>Feb 26 2021</TD></TR><TR><TD>Feb 27 2021</TD></TR><TR><TD>Feb 28 2021</TD></TR><TR><TD>Mar 01 2021</TD></TR><TR><TD>Mar 02 2021</TD></TR><TR><TD>Mar 03 2021</TD></TR><TR><TD>Mar 04 2021</TD></TR><TR><TD>Mar 05 2021</TD></TR><TR><TD>Mar 06 2021</TD></TR><TR><TD>Mar 07 2021</TD></TR><TR><TD>Mar 08 2021</TD></TR><TR><TD>Mar 09 2021</TD></TR><TR><TD>Mar 10 2021</TD></TR><TR><TD>Mar 11 2021</TD></TR><TR><TD>Mar 12 2021</TD></TR><TR><TD>Mar 13 2021</TD></TR><TR><TD>Mar 15 2021</TD></TR><TR><TD>Mar 16 2021</TD></TR><TR><TD>Mar 17 2021</TD></TR><TR><TD>Mar 18 2021</TD></TR><TR><TD>Mar 19 2021</TD></TR><TR><TD>Mar 20 2021</TD></TR><TR><TD>Mar 21 2021</TD></TR><TR><TD>Mar 22 2021</TD></TR><TR><TD>Mar 23 2021</TD></TR><TR><TD>Mar 24 2021</TD></TR><TR><TD>Mar 25 2021</TD></TR><TR><TD>Mar 26 2021</TD></TR><TR><TD>Mar 27 2021</TD></TR><TR><TD>Mar 29 2021</TD></TR><TR><TD>Mar 30 2021</TD></TR><TR><TD>Mar 31 2021</TD></TR></TBODY></TABLE></TD><TD>Count <TABLE><TBODY><TR><TD>1</TD></TR><TR><TD>368</TD></TR><TR><TD>13</TD></TR><TR><TD>421</TD></TR><TR><TD>5</TD></TR><TR><TD>526</TD></TR><TR><TD>243</TD></TR><TR><TD>228</TD></TR><TR><TD>25</TD></TR><TR><TD>8</TD></TR><TR><TD>383</TD></TR><TR><TD>571</TD></TR><TR><TD>464</TD></TR><TR><TD>194</TD></TR><TR><TD>373</TD></TR><TR><TD>45</TD></TR><TR><TD>12</TD></TR><TR><TD>485</TD></TR><TR><TD>713</TD></TR><TR><TD>912</TD></TR><TR><TD>930</TD></TR><TR><TD>1615</TD></TR><TR><TD>161</TD></TR><TR><TD>46</TD></TR><TR><TD>851</TD></TR><TR><TD>835</TD></TR><TR><TD>695</TD></TR><TR><TD>458</TD></TR><TR><TD>471</TD></TR><TR><TD>49</TD></TR><TR><TD>10</TD></TR><TR><TD>372</TD></TR><TR><TD>491</TD></TR><TR><TD>415</TD></TR><TR><TD>238</TD></TR><TR><TD>281</TD></TR><TR><TD>20</TD></TR><TR><TD>1</TD></TR><TR><TD>302</TD></TR><TR><TD>406</TD></TR><TR><TD>461</TD></TR><TR><TD>321</TD></TR><TR><TD>32</TD></TR><TR><TD>20</TD></TR><TR><TD>5</TD></TR><TR><TD>368</TD></TR><TR><TD>386</TD></TR><TR><TD>431</TD></TR><TR><TD>241</TD></TR><TR><TD>367</TD></TR><TR><TD>17</TD></TR><TR><TD>5</TD></TR><TR><TD>358</TD></TR><TR><TD>316</TD></TR><TR><TD>323</TD></TR><TR><TD>8</TD></TR><TR><TD>148</TD></TR><TR><TD>9</TD></TR><TR><TD>1</TD></TR><TR><TD>236</TD></TR><TR><TD>324</TD></TR><TR><TD>364</TD></TR><TR><TD>142</TD></TR><TR><TD>190</TD></TR><TR><TD>11</TD></TR><TR><TD>5</TD></TR><TR><TD>193</TD></TR><TR><TD>324</TD></TR><TR><TD>311</TD></TR><TR><TD>123</TD></TR><TR><TD>185</TD></TR><TR><TD>14</TD></TR><TR><TD>221</TD></TR><TR><TD>313</TD></TR><TR><TD>352</TD></TR><TR><TD>194</TD></TR><TR><TD>931</TD></TR><TR><TD>41</TD></TR><TR><TD>2</TD></TR><TR><TD>293</TD></TR><TR><TD>290</TD></TR><TR><TD>238</TD></TR><TR><TD>95</TD></TR><TR><TD>196</TD></TR><TR><TD>15</TD></TR><TR><TD>220</TD></TR><TR><TD>281</TD></TR><TR><TD>212</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I am trying to get SD and AVE&nbsp; for each month. I tried using&nbsp;</P><DIV><DIV><SPAN>SD =&nbsp;</SPAN><SPAN>CALCULATE( STDEVX.P('Sheet1','Sheet1'[Count]), allselected('Sheet1'))</SPAN></DIV><DIV><SPAN>but it computes for the entire data.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Please help. Thanks in advance</SPAN></DIV></DIV> Mon, 28 Jun 2021 10:04:04 GMT https://community.fabric.microsoft.com/t5/Developer/Standard-Deviation-and-Averaging/m-p/1925528#M30207 j4ymastah 2021-06-28T10:04:04Z Re: Standard Deviation and Averaging https://community.fabric.microsoft.com/t5/Developer/Standard-Deviation-and-Averaging/m-p/1929545#M30228 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/309793">@j4ymastah</a>&nbsp;</P> <P>You can add a YearMonth column in your data model. Then you can achieve your goal by measure or calculate funtion in Table visual directly.</P> <P>Add a YearMonth column.</P> <LI-CODE lang="markup">YearMonth = FORMAT('Table'[LOGIN DATE - Copy],"YYYYMM")</LI-CODE> <P>Measure:</P> <LI-CODE lang="markup">SD Per Month = CALCULATE(STDEV.P('Table'[Count]),FILTER(ALL('Table'),'Table'[YearMonth]=MAX('Table'[YearMonth])))</LI-CODE><LI-CODE lang="markup">AVG Per Month = CALCULATE(AVERAGE('Table'[Count]),FILTER(ALL('Table'),'Table'[YearMonth]=MAX('Table'[YearMonth])))</LI-CODE> <P>Or use Average/S<SPAN>tandard Deviation function in table visual.</SPAN></P> <P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1.png" style="width: 213px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/543665i4A4184D348D32592/image-dimensions/213x606?v=v2" width="213" height="606" role="button" title="1.png" alt="1.png" /></span></SPAN></P> <P>Result is as below.</P> <P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2.png" style="width: 730px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/543667i7EF3254660C73502/image-size/large?v=v2&amp;px=999" role="button" title="2.png" alt="2.png" /></span></SPAN></P> <P><SPAN>Best Regards,</SPAN></P> <P><SPAN>Rico Zhou</SPAN></P> <P>&nbsp;</P> <P>If this post <STRONG>helps</STRONG>, then please consider <EM><STRONG>Accept it as the solution</STRONG></EM> to help the other members find it more quickly.&nbsp;</P> <P>&nbsp;</P> Wed, 30 Jun 2021 03:11:27 GMT https://community.fabric.microsoft.com/t5/Developer/Standard-Deviation-and-Averaging/m-p/1929545#M30228 Anonymous 2021-06-30T03:11:27Z Re: Standard Deviation and Averaging https://community.fabric.microsoft.com/t5/Developer/Standard-Deviation-and-Averaging/m-p/1941367#M30370 <P>And that fixes it! Many thanks, @Anonymous</a>&nbsp;</P> Wed, 07 Jul 2021 00:23:11 GMT https://community.fabric.microsoft.com/t5/Developer/Standard-Deviation-and-Averaging/m-p/1941367#M30370 j4ymastah 2021-07-07T00:23:11Z