Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Identify rows with row above

Hi all,
My cliente has a table like this:

Rick_ferreira_0-1626443453426.png

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

Rick_ferreira_1-1626443583732.png

There will be any way to to that?

Thanks

1 ACCEPTED SOLUTION
fhill
Resident Rockstar
Resident Rockstar

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

fhill_0-1626444944062.png

fhill_0-1626445219185.png

 

fhill_1-1626445041902.png

 

fhill_2-1626445060254.png

 




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




View solution in original post

3 REPLIES 3
fhill
Resident Rockstar
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




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




fhill
Resident Rockstar
Resident Rockstar

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

fhill_0-1626444944062.png

fhill_0-1626445219185.png

 

fhill_1-1626445041902.png

 

fhill_2-1626445060254.png

 




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




Anonymous
Not applicable

Yes it is using power query

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors