Split table into another table based on column value

[Anonymous]

I have a table that is really messy.

Column 1 has the values Test 1 and Test 2 among others and i want to split this table to another table so every row after Test 2 goes to a new table. How do i do that?

[V-lianl-msft]

Hi @Anonymous ,

You can create a new calculated table.

Please try the DAX below:

Table 2 = CALCULATETABLE('Table','Table'[id]="Test2")

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

This should help - calculatetable

https://docs.microsoft.com/en-us/dax/calculatetable-function-dax

[Anonymous]

Thank you for your answer but this is not exactly what i am looking for.

As i said the table is messy. So in column 1 the header (Test 1) is not actually a header but is inside the table as there are some stuff above it. Below this there is the same thing with Test 2 as the header. What i basically want to do is get every value after test 2.

Irrelevant stuff	Irrelevant stuff	Irrelevant stuff	Irrelevant stuff	Irrelevant stuff
Test 1
	# Header 1	# Header 2	#Header 3	# Header 4	Header 5
All Markets - TOTALS / AVERAGES	value	value	value	value	value
United Kingdom	value	value	value	value	value
United States	value	value	value	value	value
Canada	value	value	value	value	value

@V-lianl-msft 

[V-lianl-msft]

Hi @Anonymous ,

See if this article can help you:split-segment-partition-section-your-table-in-power-bi-power-query 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[V-lianl-msft]

Hi @Anonymous ,

I'm sorry, but I really can't understand the sample data you sent.Could you please show me the picture of the data ?(Please mask any sensitive data before uploading)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

so i want everything from flight and down to be in a different table.

@V-lianl-msft