How to create year range table in Power Query Editor?

Question

In Power BI ,  I need to auto generate year range table start from 1900 to 2050 in Power Query Editor, How I can do that ?

Answer 1

Auto-generate year range table in Power Query Editor in Power BI

Steps

1. From Query Editor > Home tab and select New source > Blank Query .
   
2. Enter the name of the list
   

3. From the Home tab select Advanced Editor and paste the below code based on your year range.

     let
     Source = {1900..2050},
     #"ConvertToList1"={Source},
     #"ConvertToList2"=#"ConvertToList1"{0}
     in
     #"ConvertToList2"
   

   

4. Great, the year table is created based on the specified range!