Need help with standart deviation

Question

Hello!&nbsp;I have ad campaigns, budget and weeks.&nbsp;How can I check standard&nbsp;deviation of budget on week from previous weeks (5 for example)?&nbsp;

greg_deckler · Answer

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

v-cherch-msft · Answer

Hi&nbsp;MarkShu&nbsp;Below is the similar post for your reference. If it is not your case, please share more details for your scenario so that we could help further on it.https://community.powerbi.com/t5/Desktop/DAX-Variance-vs-Budget/td-p/104905&nbsp;Regards,Cherie

markshu · Answer

I want to compare standard&nbsp;deviation of budget ad campaign&nbsp;to in rubles week to week. For example in last week more then 2 standard&nbsp;deviations from ordinary values, then I will understand in this week I have problems. If standard&nbsp;deviation less then 2, then all are in normal range. But if I just use STDEV.P/STDEV.S function I have standard&nbsp;deviation within one week without comparing with previous weeks.&nbsp;

v-cherch-msft · Answer

Hi&nbsp;MarkShu&nbsp;&nbsp;Here are some articles for your reference.https://www.sqlbi.com/articles/rolling-12-months-average-in-dax/https://community.powerbi.com/t5/Desktop/StdDev-from-Mean-by-Category/td-p/72871&nbsp;Regards,Cherie

markshu · Answer

Hi&nbsp;v-cherch-msft!I done something already, but I have issue.&nbsp;I have this:start date = IF(NOT ISBLANK (sum('А'[Budget));CALCULATE(FIRSTDATE('Date'[Date]);ALLSELECTED('Date')))finish date&nbsp;= CALCULATE(LASTDATE('Date'[Date]))n = IF(SUM('А'[Budget])&gt;0;CALCULATE(SUMX(SUMMARIZE('А';'Date'[Week];"S";SUM('А'[Budget]));1);DATESBETWEEN('Date'[Date];[start date];[finish date])))x(i) = IF(SUM('А'[Budget])&gt;0;CALCULATE(SUM('А'[Budget]);DATESBETWEEN('Date'[Date];DATEADD(FIRSTDATE('Dat'[Date]);-7;DAY);DATEADD(LASTDATE('Date'[Date]);-7;DAY))))|x| = IF(SUM('А'[Budget])&gt;0;DIVIDE(CALCULATE(SUM('А'[Budget]);DATESBETWEEN('Date'[Date];[start date];DATEADD(LASTDATE('Date'[Date]);-7;DAY)));[n]-1))But then I try to calculate E&nbsp;(x(i)-|x|)^2&nbsp;I recieve nothing, even error does not show.&nbsp;E (x(i)-|x|)^2 = IF(SUM('А'[Budget])&gt;0;SUMX(SUMMARIZE('А';'Date'[Week];"D";POWER([x(i)]-[|x|];2));[D]))

Forum Discussion

Need help with standart deviation

5 Replies

Related content

Standard Deviation

Deviation from average - how?

Standard Deviation DAX

Standard Deviation of total sales

Standard Deviation