Dave 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
Here’s a question we got via our Facebook group:Any idea why the Microsoft Teams is missing from my Windows 10 taskbar? I can’t find the icon anywhere, and it’s making it difficult to access the app quickly. How can I get Teams to appear in the taskbar again? Any ideas are appreciated.. Solve the Teams … Read more
Power Query imports date values as plain text more often than expected, especially from CSV files, web sources, and databases with inconsistent schemas. Text-formatted dates break time intelligence calculations, prevent chronological sorting, and block date-based filters in both Power BI and Excel. Converting these text columns to proper date values requires the right combination of … Read more
Here’s a question i often encounter at work: I need to save some important videos from my Microsoft Teams chats, meetings, channels, as well as Microsoft Stream. How can I download these videos to my computer?” Save video files from Microsoft Teams to your computer Downloading videos from Microsoft Teams and Stream can be useful … Read more