Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Create Table with Generateseries() and a String Value
09-20-2022
02:29 AM
Dear community,
the problem seems simple to solve, somehow it doesnt work as planned.
What I want to achieve is the following. I want a table with the following Cells
--------------------
"Please select"
1900
1901
1902
...
2022
--------------------
What I already have is:
Table = GENERATESERIES(1900, 2022, 1)
So I just need to add "Please Select".
The data type should be "Text" for this table.
Any ideas? I know it should be actually easy...
Best regards and many thanks in advance,
Phil
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-20-2022
02:31 AM
@Shifty1993 Try:
UNION( GENERATESERIES(1900, 2022, 1), { "Please select" } )
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...
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-20-2022
02:31 AM
@Shifty1993 Try:
UNION( GENERATESERIES(1900, 2022, 1), { "Please select" } )
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...

Helpful resources
Announcements
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors (Last Month)
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |