How to convert Outlook appointments into Teams meetings?

“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

How to merge tables based on two columns in Power BI?

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

How to create a rolling 12-month average in Power BI?

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

How to create a fiscal year calendar in Power BI?

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

Microsoft Teams icon not showing up in taskbar

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

How to convert text columns to dates in Power Query?

Converting your data to different types is a common (and time consuming :-)) task in data transformation. Power Query provides simple methods to handle conversion, enabling simpler and more performant ETL processes for subsequent analysis. In today’s post we will show to extract date values from text or string data. Converting Text to Date in … Read more

Teams meeting chat notes not available after meeting has finished

Eddy asks: Why can’t I see the meeting chat history from my Teams meeting after it’s ended? Is there a way to keep the chat available?” Troubleshoot Teams chat persistence issues The issue you’re experiencing with Teams meeting chat disappearing is probably related to chat persistence settings. Let’s see how to fix this issue. We … Read more

How to change channel ownership in Microsoft Teams?

Corey asks: As a team admin I need to change who’s in charge of our project channels. How do I keep the channel owner list fully updated – including adding and removing owning users as needed for the different panel. THis is absolutely critical as we are going through some restructuring. Our answer: Managing channel … Read more