Forum Discussion
Identify rows with row above
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
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
3 Replies
- fhill
Resident Rockstar
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
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