Identify rows with row above

[Anonymous]

Hi all,
My cliente has a table like this:

To create measure and graph I need to identify the columns I am think to do something like this:

There will be any way to to that?

Thanks

[fhill]

Is this imported data into PowerBI thru Power Query (where we can manipulate the data structure) or something like Direct Query where we have to do this all via Measures?

Forrest

[fhill · Accepted solution]

1. Create a Custom Column to identify only the header rows (used simple Text.Contains here, but you logic may be more complicated depending on true data?)

2. Now that the new colum has our headers and 'null' everywhere else, we can FILL DOWN on the new Column

3. Finally, apply a filter to remove the header rows

[Anonymous]

Yes it is using power query