This video is part of DiscoverEI's DAX for Enviro's series, and walks through how to calculate longterm averages and moving averages for daily rainfall data using DAX in Power BI. We explore the CALCULATE, ALL, ALLSELECTED and DATESBETWEEN DAX functions, and take it to the next level by creating a dynamic moving average analysis using What If parameters. If you're keen to explore the Power BI report that we create in this video, then head on over to DiscoverEI's website and check out the Power BI report and blog here: https://www.discoverei.com/blog/categ...

If you're interested in learning more about Power BI applications for the environmental industry, then head on over to our website for project examples: https://www.discoverei.com/, take a look at our exciting training courses: https://www.discoverei.com/training, check out our blog posts: https://www.discoverei.com/blog or join in the fun with the community at our #PowerBI4Enviro’s Meetup group: https://www.meetup.com/enAU/powerbi4

Thanks for watching and have fun exploring DAX in Power BI!