Forum Discussion

HaosonNian's avatar
HaosonNian
Regular Visitor
2 years ago

List.Generate with 2 Parameters

Hi everyone, 

 

I have a question regarding the use of 2 parameters using the List.Generate function. I have an understanding of how pagination works with just using the page variable but using both a page and datetime parameter is a little more complex. 

 

= List.Generate(()=>
[Result = try fRecordsFD(1) otherwise null, Page=1], 
each [Result]<>null, 
each [Result = try fRecordsFD([Page]+1) otherwise null, Page=[Page]+1], 
each [Result])


Ideally, I'd like to pull the dates from a table which uses dates from every 6 months. 

 

Thanks! 

 

1 Reply

  • List.Generrate has 4 parameters. fRecordsFD seems to be your own custom function?

    Please provide your starting data, your existing code and the result you are looking for...