Forum Discussion
HaosonNian
2 years agoRegular Visitor
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
- PwerQueryKeesSuper User
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...