This video is part of DiscoverEI's DAX for Enviro's series, and walks through an example of how to use Power BI for water resource management. We show how to analyse total system dam storage volumes across 120 different modelling scenarios in Power BI using the DAX iterators: AVERAGEX, MINX and MAXX. We take it to the next level by configuring error bands for the minimum and maximum storage outlook volumes to show the range of possible scenarios. 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!