

July 1, 2021

Hi Everyone,
I am enclosing herewith a text file which I would like to convert as a Final Output as per the sample attached using Power Query.
I would really appreciate for any help in this matter
Thanks in advance.
Rashid


Trusted Members
Moderators
Power BI

January 31, 2022



Trusted Members
Moderators
Power BI

January 31, 2022



July 1, 2021

Dear Riny,
Extremely sorry.
I attached a wrong sample txt file. Please find herewith the correct file,
The output file is a sample of the output required where you may find some companies missing but you will get the overall idea of the output required.
As this is done by manual copy and pasting so chances are there some records might be missing.
Thanks for your time.


Trusted Members
Moderators
Power BI

January 31, 2022

The attached PQ solution isn't going to win a prize for being the most beautiful piece of art, but it seems to work. The last two columns with amounts agree to the Output file you sent earlier. The first, however, does not. Several larger amounts are missing the first digit(s).
Please check it carefully.

Answers Post
1 Guest(s)
