MSBI Tutor

Time-based analysis is at the heart of business intelligence. Whether you’re comparing sales from two years ago, analyzing last month’s performance, or calculating totals for the current quarter, time intelligence is essential. While Power BI has long supported time-based calculations,  existing functions  come with limitations: No built-in support for week-based calculations. Requirement for a continuous date table. Limited flexibility for non-Gregorian calendars (e.g., fiscal, lunar, retail). Introducing  calendar-based time intelligence —a powerful and flexible way to work with any calendar structure in Power BI.   What Are Calendars? In Power BI, calendars define which columns in a table represent specific time attributes, enabling customized time-based analysis. You can define multiple calendars on any table, giving you full control over how time is segmented and analyzed.   Key Benefits Works with any calendar: Gregorian, shifted Gregorian, retail (44...

Mac users, rejoice — semantic model editing in the Power BI service is now generally available, bringing core modeling capabilities to the web. Create New Semantic Models in the Web You can now create new import semantic models from over 100 connectors, all within your browser. Getting started: 1. Navigate to the Create page and select Get data. This will launch the  modern Power Query Get Data experience  for you to discover and connect to data including sources like Excel, SharePoint, SQL Server, and more! 2. Choose your data source and configure connection settings. 3. Select the tables you want included in your semantic model. From here you have the following 3 options: Option 1: Create a report This option takes you into the report editing experience in the Power BI service. Here, you can immediately start building a report on top of your newly created semantic model. The report editor provides all the familiar tools for designing visuals, adding filters, and customi...