Brilliant people delivering brilliant business solutions

About Us

Satalyst assists companies to realise the business benefits technology can offer. When you engage with Satalyst, you're buying more than IT services, you're investing in the best solution to drive your business value through the innovative use of technology.

Learn More

Our People

Damien Herbert

Software Architect
Damien has more than 9 years’ experience working with Java and enterprise architecture. His expertise is in financial services and insurance. Damien has worked both in Australia and the UK for leading international organisations delivering and supporting multi-time zone, real time solutions.
View more profiles

Latest Blog

19.05.15 By Leah Kaplan Categories:

Power Query: Creating a parameterized function in M

This will be part two in my on-going series about Power BI, Power Query, and the general joys of data. In my last post I outlined how to iterate over a list in Power Query. But what if I want to iterate over a list and need to parameterize it with today’s date? What if I want to issue multiple web requests based on a list? This is exactly the scenario I had when trying to fetch crime data from the WA Police web site. First, I have to thank my colleague and web wizard John Chillemi who authored the azure website that I’m using. The WA Police site has all the data, but not in a nice HTML table, which is what Power Query needs. So, thanks to John, I can execute a single web request and get a webpage that looks like this:   The web request takes five parameters – Suburb, Start Month, Start Year, End Month, and End Year, as seen below: I’d like to execute that web request for every suburb in Western Australia (there are over 1300 by my count) so obviously this is a case for automation, which means I need an M parameterized...
Visit our blog

Delivering brilliant business solutions