Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Download 2 Chapters: 8 – CALCULATE() –… READ MORE
The project If you’ve been reading my posts, you may know by now, that I’m often trying to find out ways to push the limits of the Power Platform in its citizen developer statement. At the recent MS Ignite conference there’s been a few changes and features releases. 2 of those features are focused in this article:… READ MORE
Currency conversion applied to BI reports can include many different scenarios. Data in multiple currencies, report with a single currency Data in multiple currencies, report with multiple currencies Data in a single currency, report with multiple currencies The rule of thumb is to apply the currency exchange conversion upfront. Therefore, it is a good idea… READ MORE
Early February we released an exciting new feature that enables you to add telemetry logging to your application using Application Insights. That blog post can be found here: https://powerapps.microsoft.com/en-us/blog/log-telemetry-for-your-apps-using-azure-application-insights/ This blog post is a walk through for getting that running specifically for creating a send a smile experience from your Power Apps. You can also find… READ MORE
Many people spend time focusing on automating their build and deployment assuming that this will improve the quality of the output. While it definitely reduces the time needed to build or deploy solutions and certainly reduces human errors which can cause defects. Automating the build and release is only part of the story. We must… READ MORE
This is the last blog post in a series of four about Virtual Entities. We have reached the moment where we will put all the pieces together in order to get a working example of Virtual Entities. In my previous blog posts I have given an introduction to Virtual Entities and showed how to create… READ MORE
In Part 1 I unveiled my method of applying the Ask in PowerApps property efficiently. As an example I used a simple form with Text input fields. In this Part I will go one step further, using Collections. I use collections whenever I need to gather groups of items with similar characteristics. For example cars, groceries, Orders, kitchenware..etc..etc.. I… READ MORE
In my previous blog, I spoke about how to create your first UI flow. If you have not read that yet, then please do so as it is a prerequisite for this one. You can find Part 1 here. Ok, so I am now working on the assumption that you have read part 1. In… READ MORE
Hands on workshop walking attendees through integrating PowerApps and Power BI to create a scoreboard application. A video of these steps can be seen at: https://www.youtube.com/mspowerplatform Step 1. Create an app workspace to host the application. To do this: Log in to PowerBI.com and click on Workspaces > New Workspace. For people doing this at… READ MORE
I recently spoke to a new client about Power Automate, and as I ran through the list of considerations –licensing, self-service purchasing, administration– I realized that I hadn’t provided enough information about environments to really help drive their understanding. Here was a client that already had a process in place for developing new solutions and… READ MORE
