Forum Discussion

jeffreyweir's avatar
jeffreyweir
Icon for Helper III rankHelper III
8 years ago
Solved

Generate a list from data stored in two columns

Hi folks. I'm trying to 'expand'  a Table by creating a new column that for each record contains all the numbers between TP_Start and TP_End.  Here's what I've got currently:     I know that...
Need Help
  • jeffreyweir's avatar
    jeffreyweir
    8 years ago

    Ahh...I see now that I was trying to shoot a mosquito with a cannon, to quote MarcelBeug

     

    #"Added Custom" = Table.AddColumn(#"Expanded TimePeriod", "TradingPeriod", each {[TP_Start]..[TP_End]}),

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Try this M code instead

 

={Number.From([TP_Start])..Number.From([TP_End])}

  • francisco_marco's avatar
    francisco_marco
    Frequent Visitor
    3 years ago

    It works perfectly. If the columns are already a number is even simpler: {[TP_Start]..[TP_End]}

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      3 years ago

      Glad to know that.

  • jeffreyweir's avatar
    jeffreyweir
    Icon for Helper III rankHelper III
    8 years ago

    Ahh...I see now that I was trying to shoot a mosquito with a cannon, to quote MarcelBeug

     

    #"Added Custom" = Table.AddColumn(#"Expanded TimePeriod", "TradingPeriod", each {[TP_Start]..[TP_End]}),