There’s a few blogs out there which try to explain the problem and solutions. I looked at them and found that they were not always the easiest to wrap your head around. So, here is my solution which is hopefully a bit easier to understand and implement in your environment if needed.The Business Problem: I … Continue reading DAX & The Month-over-Month Delta
Like many others, I do not want displayed measures in my PowerBI to show (blank) – it’s generally too ambiguous and just plain ugly. I generally use an IF statement in my DAX code to replace (blank) with 0, as that is a more accurate representation of my data. There is another issue….I have experienced … Continue reading PowerBI & That Pesky (blank) & Our Friend The BOOLEAN
Off track a little for my usual posts.....I purchased some AirPods at Christmas and been having a lot of issues. Intermittent connectivity, call audio not routing properly, Siri audio not routing etc. just extremely frustrating. Spoke to Apple Support who sent a replacement pair. Pretty much the same issue. So after some researching, discovered a … Continue reading Apple AirPods & Tile
How do you bulk upload data to a SharePoint Online list? I am sure for many businesses this is a common task. For the last few weeks, I had a very effective albeit manual solution: Have a list of the data I wish to upload in an Excel file, structured to match my columns on … Continue reading The Bulk Uploading Of Data (Programmatically) To A SharePoint Online List
I am currently in the middle of creating some custom tooling and surfacing the outcomes in PowerBI. I created a DAX measure to provide some insights as to whether a trip was currently in-progress or had concluded. Writing the measure was fairly straightforward using a combination of a custom calculated column based on cross-referencing the … Continue reading Changing (Blank) To Numeric Zero
This is the excerpt for your very first post.