Forecasting data with out weekends (Excluding Saturday and Sunday days)

[kolturra]

I am trying to use forecast option in Power BI in which i am want to forecast data excluding Saturday and Sundays. Can some one please help or show me how to do this activity. Below data what i am using.

Thanks,

K Raghavender Rao

[v-easonf-msft]

Hi , @kolturra 

When I tried to use your sample data for testing, I found that the time interval  is too messy to make prediction data.

Please make sure that  your dates in  valid timeline have a consistent gap between consecutive point first.

Best Regards,
Community Support Team _ Eason

[kolturra]

Hi,

Data what i have is excluding Satruday and Sunday. I only want to forecast in line chart for weekday data which is Mon to Friday.

Thanks,

K Raghavender Rao

[v-easonf-msft]

Hi , @kolturra 

Here  is  a test demo.

After my research, I'm afraid it couldn't achieve in Power BI for now.

For your requirement , it is suggest to come up with a new idea and add your comments there to make this feature coming sooner. https://ideas.powerbi.com/forums/265200-power-bi-ideas

Best Regards,
Community Support Team _ Eason

[kolturra]

Hi,

Thanks very much. I have updated this request in Idea community.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/40296790-forecast-for-only-weekda...

Thanks,

K Raghavender Rao

[Greg_Deckler]

I would add a column to you table like:

WeekDay = WEEKDAY([Date],2)

Then a measure like:

Measure = SUMX(FILTER('Table','Table'[WeekDay] < 6),'Table'[Value])

Use the Measure in your visual and forecast should now exclude weekends