Power BI Exculuding Outliers

[esero88]

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. 

[v-shex-msft]

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

[v-shex-msft]

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