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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
depple
Helper III
Helper III

Get data from "header" rows as column

Hi,

 

Is there a way that I could get the date in row 1 column 5 as a column in my table (starts on row 5)?

 

PBIC.JPG

 

Any suggestions would be highly appreciated.

 

/depple

2 REPLIES 2
TomMartens
Super User
Super User

Hey,

 

I'm not sure if I understand your query correctly, but maybe this is what you are looking for:

 

  1. Remove top 4 rows
    image.png
  2. "Promote" 1st row to headers
    image.png

Hopefully this is what you are looking for.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Hi @TomMartens ,

 

Thank you for looking into my question.

 

It it not about table headers per se (I misused the 'header' term because the date is placed in the header of the source document). The context here is gathering data from a folder with multiple similar reports, and therefore I need this time-stamp to separate each report in my joint table.

 

In other words: I would like to add a column to the data table with this date.

 

Sorry for poor explaining...

 

/depple

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.