Splitting table into smaller tables of Applicants in Power BI

[Anonymous]

I have a table called Applicant and it contains records as shown below:

Becuase this table has all applicant in it, so i want to split it to 4 applicant tables as shown below:

How can i achieve this in power BI?

Thanks

[amitchandak · Accepted solution]

@Anonymous , I power query you can add 4 copies and filter based on logic.

In dax you can use calculate table

For DAX, Create a Rank column first

Rank = Rankx(filter(Table, Table[ID] = earlier([ID]) ),[Application Name]) // Use index in place of name if needed

// add an index column in power query https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

Then filter based on calculate table

Table1= calculatetable(Table, [Rank]=1)

Table2= calculatetable(Table, [Rank]=2)

and so on

[Anonymous]

@amitchandak -  please elaborate, I didn't understand it. 

[amitchandak]

@Anonymous , If you want to be split in DAX, Based on what I got You need a rank.

Rank on Application Name or an index column, inside same id

Rank will be a new column, that you can use to split into 4 tables.

You can use calculatetable to create 4 tables, with filter on rank from 1,2,3,4