forecasting

[YasirBilal]

hello everyone

question is

i have 12 year of data from 2008 to 2019 so what i want to do forecast every month of 2020 based on data i have i know about build in forecast option but that's not working for me i want to have forecast value on table any way i can get this thing done without using build in forecast function...

[V-lianl-msft]

Hi @YasirBilal ,

Please refer to this thread:https://community.powerbi.com/t5/Desktop/How-to-forecast-sales-with-Power-BI/td-p/347779 

Best Regards,

Liang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@YasirBilal you need to provide more details on how your data looks like, what are the table and relationship of these tables?

Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[YasirBilal]

@parry2k Sorry can't share real data but i'm adding a screenshot how my data look like

So what i want to do is to forecast that give me forecast value of each product by Date wise like the date i have in my example screenshot from last 3 days i do many research but with build in forecast function i can't get forecast by each site and by each site product that not a full dataset i just sharing what it's look like but i do want to tell i have last 12 year sale what my boss want me to do make a table that show forecast by each site as well as each product by month...

what i'm trying to find some kind of dax meauser or anything that i can use on table visual and find forecast value of each site with each product 

short word i need to find 2020 each month of forecast value per site and per product and show into table visual

with line chart and build in forecast function i able to find forecast but i have to use filter for each site and each product to get value and i have a large dataset so going to take lot of time if i use build in forecast function

thank you