How to convert time duration to days, minutes, decimal numbers?

I have employee time tracking data, and I need to analyze and visualize work durations in different formats for reporting purposes. Any idea about how to transform duration data to time units? Get time units from time duration in Power BI This tutorial will guide you through the process of transforming duration data into various … Read more

How to convert dates to Month and Year in Power BI?

I have a dataset with employee performance reviews, including periodical HR review dates. Need to create a visual in Power BI that shows the number of reviews conducted each month and year, without showing the specific day. I’m struggling to group the dates correctly and extract just the month and year information and ideas here? … Read more

How to extract numbers from text strings in Power BI?

Use case I have a column in my database in which i have an employee IDs that is mixed with text (e.g., ‘EMP12345’ or ‘EMPLOYEE12345’ for example). The text length is not fixed. How can I extract just the numeric part in Power BI for further analysis and visualization? Introduction Extracting numeric data from text … Read more

How to convert datetimes in UTC to Local Time in Power BI?

Question I have an HR attendance dataset with UTC timestamps, but I need to display local times in my Power BI reports. How can I convert UTC to local time for accurate reporting across different time zones? Is there a way to handle daylight saving time changes automatically? Introduction Power BI offers robust solutions to … Read more

How to find the Webex meeting recording location?

Here’s a question:I recently hosted a Webex meeting and need to access the recording for reference and to share with team members who couldn’t attend. I know how to find my Microsoft Teams recording folder; however, I’m struggling to locate where Webex has saved the recording on my computer. Can you provide a detailed guide … Read more

How to set your Webex status to away or offline?

Here’s another question from our Facebook group: I work remotely and use Webex for team communication. However, I’m finding it difficult to manage my availability, especially when I need uninterrupted focus time or when I’m stepping away from my desk. How can I effectively set my Webex status to ‘away’ or ‘offline’ to let my … Read more

Microsoft Teams Outlook plugin not working – how to fix?

Here’s a question from a reader:I use Teams extensively for meetings with clients. Couple days ago, i got a new PC and since then I’ve been trying to use the Teams plugin in Microsoft Outlook, but it’s not functioning properly. Whenever I try to schedule a Teams meeting from Outlook, i don’t even see the … Read more