Forum Discussion
Weekly Forecasting
Hi all! I need some help here... I´m trying to create a table with sales forecast per store, based on last days in this week / month / period of time. I would like to create a table with stores in ...
- Hi guys! I solve the problem doing this: - Create a table only with the stores values (Stores = VALUES(fVendas[store]) - Create a date table (d_Tempo = VAR DataMinima = MIN(fVendas[date]) VAR DataMaxima = MAX(fVendas[date])+365 RETURN CALENDAR(DataMinima,DataMaxima) - Create a new table summarizing daily sales per store; - Create a Forecast table joining store and d_tempo table(Forecast = CROSSJOIN(SELECTCOLUMNS(Store,"Loja",Store[Loja Correta]),SELECTCOLUMNS(d_Tempo,"Data",d_Tempo[Date])); - calculate the total sale in the actual week: Acumulado Semana TB1 = VAR SemanaAtual = 'Forecast'[Week Table 1] VAR LojaCorreta = 'Forecast'[Loja] VAR ActualYear = 'Forecast'[Ano] RETURN CALCULATE( SUM('Forecast'[Vendas do Dia]), FILTER( 'Forecast', 'Forecast'[Week Table 1] = SemanaAtual && 'Forecast'[Loja] = LojaCorreta && 'Forecast'[Ano] = ActualYear ) ) - And then, an if formula: Forecast Semanal = if( 'Forecast'[Data]
amitchandak
Super User
Super UserAnonymous , Try like
new column =
var _olddate = maxx(filter('Table','Table'[store] = earlier( 'Table'[store]) && 'Table'[Date] < earlier( 'Table'[Date])), 'Table'[Date])
return
AvergaeX(filter('Table','Table'[store] = earlier( 'Table'[store]) && 'Table'[Date] =_olddate ),'Table'[sales])