For this article, I want to share a way for you to create your own Power BI “Helper Tool” and register it as an external tool in Power BI. This article carries on from some of my recent articles on how you can use Visual Studio Code to help automate specific tasks by taking advantage … Continue reading Use Visual Studio Code to create Power BI External Tool
Last time I was in Seattle, I was lucky enough to do a short video with the famous GuyInACube showing a useful technique I use when debugging DAX in Power BI. I hope you find it useful.
As an extension to my recent article on base conversions in DAX, I thought I’d show how these conversion calculations can be used to help you perform bitwise calculations in DAX. At present, there are no bitwise operators in DAX (I’m working on it!!), so calculations that need to perform AND, OR, XOR, NOT etc. … Continue reading DAX: Bitwise calculations
I was doing some work recently which required DAX calculations to convert values from a specific base to another, e.g. to convert a value in hexadecimal format to a base 10 representation (or decimal), or from base 10 to binary. Excel, like other languages has native functions to allow you to convert across base, such … Continue reading DAX: Base conversions