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