The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!
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...