Forum Discussion

ap072619's avatar
ap072619
New Member
4 years ago
Solved

Replace Value in Top Row

I'm trying to load monthly invoices from pdf files and working on my Transform Sample File. The formatting is not Power Bi-friendly and stacks the invoice number and invoice date in consecutive rows....
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi ap072619 ,

     

    You can add a custom column to return the pure number part first, and then compare it with Column3. If the custom column is equal to Column3, it means that the new line is not a date, and return null, otherwise return a date.

     

    1.Add a custom column.

     

    2.Fill up.

     

    3.Filter out the Invoice Number, remove the unneeded columns.

    Result:

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi ap072619 ,

 

You can add a custom column to return the pure number part first, and then compare it with Column3. If the custom column is equal to Column3, it means that the new line is not a date, and return null, otherwise return a date.

 

1.Add a custom column.

 

2.Fill up.

 

3.Filter out the Invoice Number, remove the unneeded columns.

Result:

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.