Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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.
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.