Custom Functions in Power Query
Develop best practices in connecting, combining and refining data sources to effectively provide automated and high-quality data for reporting and analysis.
Trusted by 220,000+ people worldwide.
In this tutorial, we cover important features of Power Query, including how to search for data sources, connect them, and shape data to meet your Power BI needs. By using the techniques showcased in this course, you will be able to save time through automation of various task and perform various complex data cleansing activities.
Melissa de Korte
Enterprise DNA Expert
- Skilled in ETL and Modelling. Delivered practical Power Query solutions in both Excel and Power BI.
- Expertise in analysing business process data. Delivering, deploying and supporting Power BI solutions throughout the organisation.
- All-round Power platform enthusiast.
Budgeting in Power BI
Analyze seasonal budget trends in Power BI by utilizing variables to manipulate data and represent the relationships between data tables.
Using Power BI visual interactions allows you to showcase data in a way that’s both compelling and easy to digest.
Virtual Relationships using TREATAS
The TREATAS function in DAX is one of the most interesting DAX formulas that you can utilise inside your Power BI models.