Dave 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
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