Solved: Re: Creating Rows in Power BI

snowrider1799 · ‎04-09-2020

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 · ‎04-09-2020

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.

View solution in original post

v-juanli-msft · ‎04-09-2020

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 · ‎04-13-2020

Thanks @v-juanli-msft and @Greg_Deckler !

Greg_Deckler · ‎04-13-2020

Nice. Yeah, small number comes first!!

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Greg_Deckler · ‎04-09-2020

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...