Conditional Table Split

[anshpalash]

Hi all,

This is one of the many files in my local folder from which Power BI is getting files. Each file has different number of IDs. So, the location of 'Parameters' row is different for every file. I want to separate this table into two. I want it to split at the 'Parameters' row for every file. Refreshing Power BI should update the two files with new information from each file. I am having a hard time figuring out a code that says something like, "If row contains 'Parameters', then split table into two. 

I would really appreciate if someone could help me out in this case. Thanks!

[mahoneypat]

Here is one way to do it dynamically.  Add a custom column with a formula like

= if [Column1] = "Parameters" then "Parameters" else null

Then do a Fill Down step in that new column, so all the rows below will have Parameters in that column.  You can now filter to include/exclude those rows as needed.

Pat

[anshpalash]

Hi @mahoneypat , I do not want "Parameters" in every row. I want to have a separate table which would have only that data which is below the row containing Parameters. Does that make sense?

[mahoneypat]

I did not expect you would want that intermediate columns with "parameters".  It is simply a way to filter to just those rows to create the table you want.  Once filtered (and perhaps after filtering a 2nd column to get rid of nulls, etc., you can delete that temporary column.

Pat