Now as we’re looking to put the Brent Oil Dataset to bed – don’t worry it’ll stay connected to our environment and we can revisit it any time it is needed – it is time to look for the next Project.
Power BI Desktop has built-in quick measures that can give you a great start beyond the auto aggregations, should those start to be not enough you can use the quick measures gallery and then after that you will have to start to learn DAX. If you want to you can start this with a site like DAX Patterns.
Quick Measures Gallery
https://community.powerbi.com/t5/Quick-Measures-Gallery/bd-p/QuickMeasuresGallery
DAX Patterns
https://www.daxpatterns.com/
SQL BI
https://www.sqlbi.com/