About Access Analytic

---

Thanks for checking us out. Our aim is to help you with Power BI and Excel

Let us know if there's topics you'd like to cover and please subscribe and click the notification item to keep informed when we release new videos.

About Us...
Jeff Robson and Wyn Hopkins are the directors of Access Analytic

Jeff is the founding Director and Principal Business Analyst at Access Analytic Solutions. He has over 20 years’ experience in chartered accounting, business management and consulting.

Wyn gained his Chartered Accountant qualification at PricewaterhouseCoopers in the UK in 2000. He was first awarded Microsoft MVP status in 2019.

Find out more about us and the team here https://accessanalytic.com.au/about-us-2-2/

Both Jeff and Wyn would love to connect up with you on LinkedIn
https://www.linkedin.com/in/wynhopkins/
https://www.linkedin.com/in/jeffrobson/

DAX and the Start Date End Date Problem aka Events In Progress

Calculating the number of people present or processes running at the end of the data or during the month is tricky and requires some clever DAX thinking You can download my file and the source data here https://aasolutions.sharepoint.com/:f:/g/AA_CPort/EhoCc6G0b8JGoYYV-uMspvQBoZQQljisdJ6Ba2qGZnZXF…

---

23 Million Rows of Data loaded into Excel

None

---

How to connect to Dynamic Arrays with Power Query and include a heading (Insider Channel)

How to add headings to Dynamic Arrays and how to load dynamic arrays into Power Query ❗The Power Query Automatic Array Naming functionality ( FROM SELECTION) is currently only on INSIDERS channel - I only realised this a few days after recording ❗ 🔽 More Stuff to Read 🔽 ***Important Point*** LAM…

---