Creating Rows in Power BI

[snowrider1799]

Any idea if i want to create 20 rows based on Year 2020?

First Row = Year (Today()), which is 2020.

E.g.

Year

2020

2019

2018

...... 

1999

[v-juanli-msft · Accepted solution]

Hi @snowrider1799 

Thanks for Greg_Deckler, with a little midyfication, it works.

Table = GENERATESERIES(YEAR(TODAY())-21,YEAR(TODAY()),1)

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[snowrider1799]

Thanks @v-juanli-msft  and @Greg_Deckler !

[Greg_Deckler]

Nice. Yeah, small number comes first!!

[Greg_Deckler]

GENERATESERIES(YEAR(TODAY()),YEAR(TODAY())-20),1)