Forum Discussion

jeffreyweir's avatar
jeffreyweir
Helper III
7 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
    7 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]}),

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
Super User
3 years ago

Glad to know that.