Create a Month as Excel For Forescast

[clarainesgg]

Hi,

I have my sales till a period. I need to add 3 more month as Excel. My data end Agost-24, so i need to add:

sep-24, Oct-24, Nov-24.

This will be dynamic.

Thanks,

Clara

[Anonymous · Accepted solution]

Hi,

Thanks for parry2k's concern about the problem and i want to offer some more information for user to refer to.

hello @clarainesgg , you can refer to the follwing solution.

Sample data

Create a calendar table.

Calendar = CALENDAR(DATE(YEAR(MIN('Table'[Date])),1,1),DATE(YEAR(MAX('Table'[Date]))+1,12,31))

Then create a measure.

MEASURE =
VAR a =
    MAXX ( ALLSELECTED ( 'Table' ), [Date] )
VAR b =
    EOMONTH ( a, 0 ) + 1
VAR c =
    EOMONTH ( a, 3 ) + 1
RETURN
    COUNTROWS ( FILTER ( 'Calendar', [Date] >= b && [Date] < c ) )

Then create a table visual and put the date of calendar table to the field and put the measure to the visual filter.

Output

Best Regards!

Yolo Zhu

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

[parry2k]

@clarainesgg Sorry not a clue what you are trying to achieve. I hope someone else can help.

[clarainesgg]

so, iof my last month is Aug'24, I need to create a my next month, that it'll be Sep. I need a calendar.

[clarainesgg]

I need to calculate the next month: Similar to this:

next_mon = NEXTMONTH(Vacunar[Last_date])

However, it is not bringing the correct data.

[parry2k]

@clarainesgg but what is the purpose of this in Power BI? What is the end goal?

[clarainesgg]

Like you drag in excel

I tried this: 

Forecast_date =

 DATEADD(LASTDATE('Vacunar'[date_]),1,MONTH)

Thanks,

Clara

[parry2k]

@clarainesgg where do you want to add this? Could you provide more context?

[clarainesgg]

So i need to need to do forecast in Power Bi. I would like to appear the future month of my forecast.