Log In
Register
Home
Active Member
December 17, 2021
Offline
hello everyone! I have to automate a process but can't find a solution. I weekly receive via email a .CSV file with x records so i have to get the first row, the last row and the row witch contains the max temperature and put all these 3 raws in a unique file to create a dynamic and automated report in PowerBI. can someone please help me?
Ps. sorry for my poor english.
Trusted Members
October 18, 2018
Offline
How about uploading a sample file of 10-15 records showing a representative sample of what you have. Then show us a mocked up solution of what you want. This will expedite getting a workable solution that is specific to your needs.
Active Member
December 17, 2021
Offline
Hi Mr. Sidman! Thank you for the answer. There is a link of a Telegram page I have created with the two files uploaded. https://t.me/+DAGt9x2ZyXVlMTZk
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi Agim,
To upload files, look after the Attachments button when you add a message, it will allow you to select the files then Upload them attached to your message.
Note that there will be 2 buttons: Select Files and Start Upload, you need to use them both.
1 Guest(s)
