Forum Discussion

esero88's avatar
esero88
Frequent Visitor
2 years ago

Power BI Exculuding Outliers

Hello, 

 

I had a problem forecasting my data when I used Power BI's own forecasting tool. Is there any way to exclude outliers from the data?

Also, I wanted to put dummy data instead of outliers period and then forecast the data according to the included dummy data. 

 

I am totally fine to use DAX to this but I don't know where to start. 

General Comment
Tips and Tricks

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi esero88 ,

    >> Is there any way to exclude outliers from the data?

    What type of outliers’ data that stored in your table? Perhaps you can provide some snap about these to help us clarify them.
    For the Dax expression, you can add if statement to check the calculation result if it out the ranges. (e.g. if you are trying to calculate percentage values, the result range can be limited ± 10)

    >>I am totally fine to use DAX to this but I don't know where to start. 

    Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    HI esero88,

    Any update on this?  Can you please share some more detail information about this issue? Without any detail sample data it is hard to clarify your scenario and test.

    Regards,

    Xiaoxin Sheng