Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
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
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
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |