Uploaded April 2025 | Updated September 2026, 2 weeks ago

---

🫶🏻Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join

🧑🏻‍🎓Learning Power BI?
Check out our online course
accessanalytic.thinkific.com

Download the file:
aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/Ev9L1D8hZlZKk6_WDYqH9UYBAif54qGHoA8z3ZOQv-qJjQ?e=yedFwN




📗 Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/


00:00 Introduction using XLOOKUP for Approximate Match
00:53 Calculating Base Tax and Threshold with XLOOKUP
02:31 Total Tax Computation with Excel Formulas
02:54 Switching to Power Query Method
05:27 Creating and Appending Tables in Power Query
08:20 Final Calculation and Output in Power Query


The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/