Dave I’m working with employee data in Power BI and need to identify missing values in certain columns. How can I use Power Query to check for null values and handle them appropriately? Checking for Null Values in Power Query This tutorial will guide you through the process of identifying and handling null values in Power … Read more
Here’s a question from our Facebook group: “I know that Teams has a built in Calendar app. That said, i do prefer to work using Outlook as my favorite email client. How can I change the time of our Teams workgroup meeting that’s already scheduled using my Outlook calendar?” Rescheduling a Microsoft Teams meeting Worth … Read more
Our challenge for today is to help create a dynamic title in Power BI that changes based on filter selections. Change report title text based on selection Data Preparation Create dynamic measures Last, go ahead and combine measures into a dynamic title: Explanations to comprehend the DAX code: Add a card visual to your Power … Read more
Here’s a question from a friend’s colleague:“How can I create a dynamic top N filter in Power BI to show the top performing employees based on sales, where N can be changed by the user?” Power bi dynamic filters based on selection In this tutorial, we’ll create a dynamic top N filter in Power BI … Read more
Here’s a question from a reader: “How can I replace null values in my data using Power Query in Power BI?” Null values can distort your data and its analysis. Hence, replacing null values in Power BI is a key part of the data preparation process. This tutorial demonstrates how to use Power Query to … Read more
Here’s a question i got from a colleague: I need to access my Teams chat history for a compliance audit, but I can’t find an easy way to download it all at once. How can I efficiently export my entire chat history from Microsoft Teams, including private and group conversations, without having to manually copy … Read more
“I have several Outlook meetings and appointments which i would like to turn into Microsoft Teams meetings (including a call link etc’) without creating a new invitation. – Is that possible? Adding teams links to existing Outlook meeting Convert Outlook to Teams meeting Here’s a step by step process to transition Outlook appointment into Teams … Read more
User Question: “How can I join two tables in Power Query based on matching values in two different columns?” Joining tables based on matching values in Power Query Data Preparation We will use a data model that includes the following tables: Step-by-step instructions Note that you can join two or multiple tables according to more … Read more
Here’s a question from a colleague: “How can I create a rolling 12-month average measure to calculate employee turnover rate using Power BI?” Rolling average measures in Power BI Data Model Let’s start by assuming the following data model:Table: EmployeeTurnoverColumns: DAX for rolling measure in Power BI Explanation The DATESINPERIOD function creates a table of … Read more
Here’s a question from a colleague:In our HR department, we often need to report based on our company’s fiscal year, which runs from April 1st to March 31st. How can I create a custom calendar table in Power BI to support our fiscal year reporting? Setup a fiscal calendar table in Power BI Creating a … Read more