Build a Reusable Calendar Table with Power Query
Original Post : Matt Allington, 24 Apr 2018 Background Technically you don’t need calendar tables to use Power BI, but for most reports that go beyond a simple Excel spreadsheet analysis, Calendars are an essential component of a successful Semantic Model. There are many different approaches to creating and maintaining [...]
Published on:
Learn moreRelated posts
Using RANK instead of RANKX in DAX
3 days ago
Deprecating Power BI Q&A
We are announcing the deprecation of Q&A, our legacy natural language tool, which will take place in December 2026. Moving forward, users ...
4 days ago
A Look At The Impact Of Calendar Based Time Intelligence On Power BI DirectQuery Performance
Calendar-based time intelligence (see here for the announcement and here for Marco and Alberto’s more in-depth article) is at least the ...
5 days ago
Boost Your Dashboards: The Role of Visual Calculations in Power BI
Visual Calculations in Power BI play a transformative role by allowing users to write calculations directly within a visual, simplifying analy...
8 days ago
Fix ANY Date Format in Excel with Copilot Function – no Power Query – no Macros!
Fix ANY Date Format in Excel with Copilot Function without any Macros. Got dates in multiple, different and difficult formats? No problem. ...
8 days ago