Hey Excel users, anyone remember this? Yes, it’s the now defunct “Lookup Wizard” which, according the MSDN Library entry of January 1996, “…helps Excel users create lookup formulas quickly. Even expert users will find the Wizard’s lookup formulas useful in advanced spreadsheet and application development projects” Well, this was obviously not the case or else this “useful” wizard would still be with us today. What “expert” Excel user can’t construct a simple Vlookup or even use the fiddly Index/Match combo?… Read More

By Alison Box
DAX Power BI in Practice 12th May 2017