Forum Discussion

procyon82's avatar
procyon82
Icon for Resolver I rankResolver I
10 years ago
Solved

Removing Outliers

Is there an easy way to remove any outliers in Power BI desktop? I am currently importing revenue from Google Analytics, but every now and then we get very large purchases that scew the averages. Co...
Need Help
  • jahida's avatar
    jahida
    10 years ago

    That reads as: In some context (CALCULATE), is the SUM > 5000?

     

    I think you want:

     

    Revenue Month  = CALCULATE(SUM('GA Ecommerce'[Revenue]), 'GA Ecommerce[Revenue] < 5000,PARALLELPERIOD('GA Ecommerce'[Date],0,MONTH))
  • v-caliao-msft's avatar
    v-caliao-msft
    10 years ago

    Hi procyon82,

     

    Now what you need is removing outliers at daily level instead of individual transactions level, right?

     

    If that is the case, you can add a new table to sum up the revenue at daily level by using SUMMRIZE function. I have tested it on my local environment, here is the sample expression for you reference.

    DailyRevene = SUMMARIZE(Daily,Daily[Date],"Daily total",SUM(Daily[Sales]))

     

    Then you can remove the outliers on daily level in this new created table.

     

    Regards,

    Charlie Liao

jahida's avatar
jahida
Icon for Impactful Individual rankImpactful Individual
10 years ago

That reads as: In some context (CALCULATE), is the SUM > 5000?

 

I think you want:

 

Revenue Month  = CALCULATE(SUM('GA Ecommerce'[Revenue]), 'GA Ecommerce[Revenue] < 5000,PARALLELPERIOD('GA Ecommerce'[Date],0,MONTH))
procyon82's avatar
procyon82
Icon for Resolver I rankResolver I
10 years ago

 

Got it to work. I am not sure what I was doing wrong earlier, but I started from scratch.

The only issue right now is that it's looking at daily revenue and not individual transactions, so I just gotta figure that out.

  • v-caliao-msft's avatar
    v-caliao-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    Hi procyon82,

     

    Now what you need is removing outliers at daily level instead of individual transactions level, right?

     

    If that is the case, you can add a new table to sum up the revenue at daily level by using SUMMRIZE function. I have tested it on my local environment, here is the sample expression for you reference.

    DailyRevene = SUMMARIZE(Daily,Daily[Date],"Daily total",SUM(Daily[Sales]))

     

    Then you can remove the outliers on daily level in this new created table.

     

    Regards,

    Charlie Liao

    • procyon82's avatar
      procyon82
      Icon for Resolver I rankResolver I
      10 years ago

      No, I wasn't looking for outliers by looking at daily totals. I was looking for individual transactions that would skew my averages.