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 →
As you can imagine, I am really enjoying playing with Power Query and Power Pivot. PowerPivot models have been around a bit longer so the software is pretty stable. Power Query is still pretty new, so occasionally we run into…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 →