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 you how to make a scenario analysis tool using Power BI What If parameters.
Read More
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 calculate the likelihood of different dam storage volumes occurring by analysing 120 different modelling scenarios in Power BI using the DAX iterator PERCENTILEX.
Read More
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.
Read More
This video is part of DiscoverEI's DAX for Enviro's series, and walks through how to calculate long-term 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.
Read More
This video blog is part of DiscoverEI's DAX for Enviro's series, and shows how to calculate your cumulative groundwater usage in Power BI using TOTALYTD, and create a DAX measure to compare against remaining groundwater licence entitlement volume.
Read More
This video blog is part of DiscoverEI's DAX for Enviro's series, and shows how to calculate species richness and abundance in Power BI using the DAX functions SUM and DISTINCTCOUNT.
Read More
This video is the first of DiscoverEI's DAX for Enviro's series, and provides an overview into what is DAX, and how to get started creating calculated columns and measures. Alice also shares some of her favourite resources for where you can go to learn more about DAX.
Read More