Dave 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
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
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
Here’s a question from Dianne: I want to access my project management channel Teams files directly from File Explorer on my Windows 11 Computer. How can I map the files i store in my channels (mostly PowerPoint and Excel spreadsheets) to File Explorer? Are those kept on my hard drive? Mapping Teams file to Windows … Read more
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
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