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?” Validate each boundary in a rolling 12-month average A reliable rolling-window measure procedure begins with a controlled test and a clear success condition. Record the current state, account, device or file involved, … 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?” Meeting chat access depends on invite path Teams meeting chat availability after a meeting is not identical for every participant. Microsoft documents that scheduled meeting attendees can usually return … 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