Magdalena has attended:
Power BI DAX course
Forecasting
How I can create forecasting just for the month when my Calendar Table have added +366 (days) and it automatically generates forecasting for a year.
How could I create forecasting for a month/year without added +366 (days) in my Calendar table?
RE: Forecasting
Hi Magdalena,
If you change the Date table DAX to below code you will only forecast next month, with the forecast code you did on Martin's DAX course.
Dates =
var MaxDate=max(tblsales[Date])
return
ADDCOLUMNS(CALENDAR(min(tblsales[Date]),EOMONTH(MaxDate,1) ),
"Year",year([Date]),
"Quarter", format([Date],"Q"),
"Month",month([Date]),
"Week",WEEKNUM([Date],2),
"Weekend",or(WEEKDAY([Date],2)=6,WEEKDAY([Date],2)=7),
"Fiscal Year","FisCal"& YEAR([Date])+if(month([Date])>8,1,0)
)
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
