Clean up your Power Fx by Dropping Explicit Boolean comparisons Something I frequently notice when reviewing other developers’ canvas applications is explicit Boolean comparisons. While there’s nothing technically wrong this this, it is redundant. If you’re in any kind of consulting or contract work, it’s likely that you won’t be Read more…
Scenario I was working with a client to build an application to allow them to better manage sales from inventory. As part of their invoice process, they export data from the application to a CSV. However, the client wanted to display a preview of this data before exporting. First I Read more…
Using a measures table in Power BI is generally considered best practice, and there are certain advantages to using one. However, I’ve found in my experience that the negatives outweigh the positives and that measure tables simply aren’t that intuitive. In Power BI, measure tables are used to contain all Read more…
Variables in Power BI can be a very powerful way to enhance your DAX expressions and expand the possibilities of what DAX can do. Before Power BI supported variables, needing to use CALCULATE and the EARLIER function were cumbersome and created difficulties for data modelers. Today, those difficulties can be Read more…
Power BI’s existing data refresh schedules are limited and remembering to manually trigger a Power BI refresh can be difficult. One of the benefits of Power BI is receiving real time data, and Microsoft took steps to enhance this benefit by adding an action in Flow to automatically trigger a Read more…
Introduction We have implemented a video tutorial that revamps the content in this blog post and uses more modern patterns that are available in 2021. View the updated tutorial here: PowerApps Tutorial: Issue Tracker – Comment History Hello and welcome to the first in the PowerApps Tips & Tricks Series! We Read more…