cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jdevalk
Frequent Visitor

Datetable next 3 months

Hi all,
I would like to create a new datetable with only next 3 months which I will use for forecasting figures.

So something like MONTH(TODAY()+1) and +2 and +3 but I have no idea how to do so.

Anyone?

BR,

Jurgen

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@jdevalk ,

from today

Calendar(today(), eomonth(today(),3) )

 

or from month start

Calendar(eomonth(today(),-1)+1 , eomonth(today(),3)

View solution in original post

2 REPLIES 2
jdevalk
Frequent Visitor

Great, many thanks!

amitchandak
Super User
Super User

@jdevalk ,

from today

Calendar(today(), eomonth(today(),3) )

 

or from month start

Calendar(eomonth(today(),-1)+1 , eomonth(today(),3)

Helpful resources

Announcements
Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.