Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys, I used to use Alteryx in my last job as a automation tool for cleaning/reshaping data. I'm new to PowerBi and not sure if it is able to do a similar task. I extract a report from my finance system, but I need to input it in a diferent format at our internal spreadsheets. It takes me hours to re-organize all the data... I need to move cells to different areas of the spreadsheet, and also delete a good part of the data located in the report. Is there a way of automating this process with powerbi or should I try another software?
Thanks
@pedroradwan , You can use power query for that
Power BI: Power Query Functions one must know
: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=36407s
Power BI - Cheat Sheet: Power Query Functions one must know
https://amitchandak.medium.com/cheat-sheet-power-query-functions-one-must-know-a8531b6e321a
Power Query Table Functions: https://www.youtube.com/playlist?list=PLPaNVDMhUXGalVK1yOQ8hV2kWTNsZW5Gq
Power Query DateTime Functions: https://www.youtube.com/playlist?list=PLPaNVDMhUXGZdm-2DIMrS54Z2J0TAxj0X
Power BI List Functions: https://www.youtube.com/playlist?list=PLPaNVDMhUXGbkShvXwEedw-cH3QBYhwvO
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |