Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

forecasting

ResolvedVersion Standard

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

Sat 21 Sep 2024: Automatically marked as resolved.

 

Training courses

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Power BI tip:

Master DAX (Data Analysis Expressions)

DAX is the formula language used in Power BI for creating custom calculations and aggregations. Invest time in learning DAX to unlock the full potential of Power BI. Understand functions like CALCULATE, FILTER, and SUMX, as they are fundamental for creating complex calculations and measures.

View all Power BI hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.32 secs.