Forum Discussion

PaulKeijzers's avatar
PaulKeijzers
Frequent Visitor
10 years ago
Solved

Iterating trough items with steps of 500 items

Hi,   i am in a situation where i need to create a loop  for example i know i have 2579 items now i want to have a table autogenerated because the number can also be 3200 or more. in the table th...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    PaulKeijzers

     

    You can reference a calculated table as below.

     

    Number Table = 
FILTER (
    SELECTCOLUMNS (
        FILTER (
            ADDCOLUMNS (
                CALENDAR ( "1970-01-01", "2020-12-31" ),
                "daysSince 1970-01-01", DATEDIFF ( "1970-01-01", [Date], DAY )
            ),
            MOD ( [daysSince 1970-01-01], 500 ) = 0
        ),
        "num", [daysSince 1970-01-01]
    ),
    //[num] <= COUNTROWS ( YourTable )
    [num] <=2579
)

     

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

PaulKeijzers

What do you mean "doesn't work"? Any error?

Check the calculated table in the attached pbix.

 

 

PaulKeijzers's avatar
PaulKeijzers
Frequent Visitor
10 years ago

Hi Eric,

 

i need it in the query editor this is done in the front and somehow it does not work as a query in the advanced editor.

 

thanks in advance,

 

Paul