https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Table-with-Generateseries-and-a-String-Value/m-p/2780200#M86973 <P>Dear community,</P><P>&nbsp;</P><P>the problem seems simple to solve, somehow it doesnt work as planned.</P><P>&nbsp;</P><P>What I want to achieve is the following. I want a table with the following Cells</P><P>--------------------</P><P>"Please select"</P><P>1900</P><P>1901</P><P>1902</P><P>...</P><P>2022</P><P>--------------------</P><P>What I already have is:</P><DIV><DIV><SPAN>Table = GENERATESERIES</SPAN><SPAN>(</SPAN><SPAN>1900</SPAN><SPAN>, </SPAN><SPAN>2022</SPAN><SPAN>, </SPAN><SPAN>1</SPAN><SPAN>)<BR /><BR /></SPAN></DIV><DIV><SPAN>So I just need to add "Please Select".</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>The data type should be "Text" for this table.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Any ideas? I know it should be actually easy...</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Best regards and many thanks in advance,</SPAN></DIV><DIV><SPAN>Phil</SPAN></DIV></DIV> Tue, 20 Sep 2022 09:29:17 GMT Anonymous 2022-09-20T09:29:17Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Table-with-Generateseries-and-a-String-Value/m-p/2780200#M86973 <P>Dear community,</P><P>&nbsp;</P><P>the problem seems simple to solve, somehow it doesnt work as planned.</P><P>&nbsp;</P><P>What I want to achieve is the following. I want a table with the following Cells</P><P>--------------------</P><P>"Please select"</P><P>1900</P><P>1901</P><P>1902</P><P>...</P><P>2022</P><P>--------------------</P><P>What I already have is:</P><DIV><DIV><SPAN>Table = GENERATESERIES</SPAN><SPAN>(</SPAN><SPAN>1900</SPAN><SPAN>, </SPAN><SPAN>2022</SPAN><SPAN>, </SPAN><SPAN>1</SPAN><SPAN>)<BR /><BR /></SPAN></DIV><DIV><SPAN>So I just need to add "Please Select".</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>The data type should be "Text" for this table.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Any ideas? I know it should be actually easy...</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Best regards and many thanks in advance,</SPAN></DIV><DIV><SPAN>Phil</SPAN></DIV></DIV> Tue, 20 Sep 2022 09:29:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Table-with-Generateseries-and-a-String-Value/m-p/2780200#M86973 Anonymous 2022-09-20T09:29:17Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Table-with-Generateseries-and-a-String-Value/m-p/2780209#M86974 <P>Anonymous</LI-USER>&nbsp;Try:&nbsp;</P> <LI-CODE lang="markup">UNION( GENERATESERIES(1900, 2022, 1), { "Please select" } )</LI-CODE> Tue, 20 Sep 2022 09:31:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Table-with-Generateseries-and-a-String-Value/m-p/2780209#M86974 Greg_Deckler 2022-09-20T09:31:43Z