Developing Business Central Extensions/Apps in Team

I picked up a new challenge these days: for one of our (quite big) customers, we need to develop a solution, based on extensions. In short: ready for the future, easy to upgrade. When I would explain the case in a paragraph, you’d say “this is not NAV”, although when you would really look deep into it, it’s ideal for an Extension-scenario, obviously in combination with Business Central.

Bron : Waldo’s Blog
Lees meer…

Combining Data From Multiple Worksheets In The Same Excel Workbook Using Power BI

It’s very common that you need to combine data from multiple worksheets in the same Excel workbook when you’re using Power BI or Power Query/Get&Transform in Excel. Indeed a lot of people have blogged about how to solve this problem, but none of the solutions I’ve found on the internet work in more complex scenarios when the data on each sheet needs some kind of transformation before it can be combined.

Bron : Chris Webb’s BI Blog
Lees meer…

User Specified Growth on an Investment using Power BI

I wrote an article earlier this year that showed how you can take a table of future growth rates (different growth rates each year) and then calculate the future value of an investment using DAX. I had a follow up question from Steve asking if it is possible to allow the user to select a growth rate from a slicer (same growth rate each year) and calculate the future value. I thought that would answer that question in this blog.

Bron : Excelerator BI
Lees meer…

Using Power Query for Extracting Non-Tabular Data from Web Pages

Ivan: I recently moved to Australia with my family. While searching for a place to live I had to look for a good pair of suburb and school. I found interesting data at https://www.myschool.edu.au/. However, there is no option to compare schools. It just gives some statistics about Australian schools, one page at a time. The information presented on a typical school profile page (e.g. Burwood Public School) is as shown below.

Bron : Excelerator BI
Lees meer…