In this lecture, we are going to look at Table Calculations and the INDEX() Function. When creating Bespoke Data Visualisations, this is perhaps the single most important function to know as it will be key to our calculations. There are very few Dashboards that I have built that does not feature this versatile Table Calculation.
