Forum Discussion
Create table with int values from min and max
I've got two different tables with an int value (year 2022 for Min and 2024 for Max).
Max Table:
Min Table:
I need to create a new table with all int values from 2019 to 2024 increasing by 1, like this:
How can I do It?
You can either write this way. it will be static.
take new table and write this Dax for contineous series of year.
New Table = GENERATESERIES(2019,2024,1)or Try this dynamic way where next year will be automatic added when data comes.
New table2 = GENERATESERIES(MIN(T1[Year]),MAX(Y1[Year]),1)I hope I answered your question!
2 Replies
Uzi2019Community Champion
You can either write this way. it will be static.
take new table and write this Dax for contineous series of year.
New Table = GENERATESERIES(2019,2024,1)or Try this dynamic way where next year will be automatic added when data comes.
New table2 = GENERATESERIES(MIN(T1[Year]),MAX(Y1[Year]),1)I hope I answered your question!
- danextian
Super User
As always, please provide a sample data (not an image), your expected result from the same sample data and the reasoning behind.
