Forum Discussion
How to split rows by 5000 records?
This might be more manual than you want, but you could do this:
1) Set an INDEX number for the original table (it's in Query Editor under Add Coluimn)
2) Under Modeling, select New Table and create 20 calculated tables like so:
Table1 = CALCULATETABLE( OrigTable, OrigTab[Index] >=1 && OrigTab[Index] <= 5000 ) Table2 = CALCULATETABLE( OrigTable, OrigTab[Index] >=5001 && OrigTab[Index] <= 10000 ) etcHope this helps
David
Update:
I found the easier way to do it. Maybe it will help someone else.
- Create an Index column
- Add the Index as a filter on the report view
- Click 'New Group' in the fields menu
- Set the required bin size. That is!
That is why I love PowerBi :)
This might be more manual than you want, but you could do this:
1) Set an INDEX number for the original table (it's in Query Editor under Add Coluimn)
2) Under Modeling, select New Table and create 20 calculated tables like so:
Table1 = CALCULATETABLE(
OrigTable,
OrigTab[Index] >=1 && OrigTab[Index] <= 5000
)
Table2 = CALCULATETABLE(
OrigTable,
OrigTab[Index] >=5001 && OrigTab[Index] <= 10000
)
etc
Hope this helps
David
Dedelman_clng,
Thank you for the fast reply and help!
I didn't see the 'Modeling'. Where is it?
You gave me an idea how to do it. I'll create a filter using the Index column and will sort the DB this way. In fact, I need these tables in CSV so there is no need to create separate queries.
Thank you so much for the inspiration!
I found the modeling. I thought it was in Queries first.
Thank you!
Update:
I found the easier way to do it. Maybe it will help someone else.
- Create an Index column
- Add the Index as a filter on the report view
- Click 'New Group' in the fields menu
- Set the required bin size. That is!
That is why I love PowerBi :)