How many keywords do you need to search for? Can you say “Needle in a haystack”???? So, you are analyzing social media posts and you need to flag any posts that contain certain keywords. The problem is your list contains…Continue Reading →
Active Tickets Active Items, Open Tickets, Outstanding Items – All names for basically the same calculation. In this video, we will discuss how to use DAX to enable the count of any “Active” item. In the sample data, there is…Continue Reading →
OK, so its not Country Flags, we are really going to play with Tags, or keywords, but I couldn’t resist this image… Today we are going to work with a field with delimited text values which we need to separate…Continue Reading →
James Philips’ keynote to kick off the 2017 Data Insight Summit in Seattle was nothing less than AMAZING!! Coming soon to Power BI will be the ability to embed PowerApps within a PowerBI canvas, creating bookmarks which are aware of…Continue Reading →
Just wanted to drop a quick post about the Microsoft Data Insight Summit held in Seattle this last week. This was an inaugural event which focused on all things Power BI, with both Power BI Desktop and Excel. It was really…Continue Reading →
Distance calculations! Over the past couple of years, I have had several clients who are using PowerPivot who want to measure the distance between two points on a map: Client to distribution center or building to building. For just a…Continue Reading →
Welcome to GirlsWithPowerTools.com! If you found this blog expecting to find scantily clad ladies with buzz saws, boy have you come to the wrong place! If you would like to learn more about the great suite of tools that Microsoft…Continue Reading →