Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |