Forum Discussion

rmcgrath's avatar
rmcgrath
Icon for Advocate III rankAdvocate III
1 year ago
Solved

Data cleaning help

I am connecting to a folder of utility invoices (PDFs).  The first table is how everything is pulled in to Power BI.  The second is what I would like to get to after cleaning/scrubbing.  Can you give...
Need Help
Show and Tell
Tips and Tricks
  • speedramps's avatar
    speedramps
    1 year ago

    In Power Query

     

    Remove top 8 rows (adjust the number of rows depeding on your table)

    Promote top row to header

    Remove rows with date = null or To

     

     

    Please click thumbs up because I have tried to help.

    Then click accept solution if it works

speedramps's avatar
speedramps
Icon for Super User rankSuper User
1 year ago

In Power Query

 

Remove top 8 rows (adjust the number of rows depeding on your table)

Promote top row to header

Remove rows with date = null or To

 

 

Please click thumbs up because I have tried to help.

Then click accept solution if it works