The following steps show how to create a new column in a table using existing custom function code. This works in Power BI as well as in Power Query in Excel: 1. Copy the function code 1: Copy the function code 2. Create new blank query in the query editor 2: Create new query 3.… READ MORE
I’ve been using my solution to extract tables from Powerpoint a lot recently. However, I’ve come across some situations where what looks like a table is actually an embedded Excel worksheet. This can be quite useful in Powerpoint as it provides the ability to create subtotals and apply other formulae. You can add these sort of… READ MORE
Seems, Excel charts is an area that till now wasn’t considered in blogs as a target for Power Query application (Get & Transform in Excel 2016). Nevertheless, PQ can replace some VBA solutions and make your workbooks macro-free. In far 2015 my colleague Zoltán Kaszaki-Krsjak shared with me a very good example of how Power… READ MORE
This is part 2 of a series of blog posts describing Power BI – Microsoft’s Self-Service BI in the cloud initiative. In this post we take a deeper look at how to find the data, the very backbone for the reporting and analysis.