Forum Discussion
How do I make my power query automation more dynamic?
I have created an automation using power query where it'll fetch data from a workbook called "Data". I have manipulated the data to achieve my desired table format. The table's final co...
https://youtu.be/Rbkbr89cuHo
1.Use Power Query to cleanse your data, combine data, format data.
2. Normalize your data
Compartmentalize your transaction table from your lookup tables
Create a calendar table
3. Create a data model relationships to your transaction table to your lookup tables
4. Create a Pivot table using power pivot
5. Within the data model editor is where you can create your measures