Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
HILGARTH
Frequent Visitor

Table with a defined number of years always starting with the actual year

I want to create a table that displays a defined number of years. The table should always start with the current year.
Example:

Number of years: = 5
Table entries therefore:
2023
2024
2025
2026
2027

 

1 ACCEPTED SOLUTION
olgad
Super User
Super User

Hi, if you want a table with all the dates withing that period then

CALENDAR(Date(Year(Today()),1,1),Date(Year(Today())+4,12,31))

If exactly a table with 5 records then
Modelling-New Table
Table = GENERATESERIES(Year(Today()),Year(Today())+4,1)
olgad_0-1677089960560.png

Please kindly kudo and accept as solution if it works for you.


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

View solution in original post

1 REPLY 1
olgad
Super User
Super User

Hi, if you want a table with all the dates withing that period then

CALENDAR(Date(Year(Today()),1,1),Date(Year(Today())+4,12,31))

If exactly a table with 5 records then
Modelling-New Table
Table = GENERATESERIES(Year(Today()),Year(Today())+4,1)
olgad_0-1677089960560.png

Please kindly kudo and accept as solution if it works for you.


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.