Blogs from Wise Owl on Dates and calendars in Power BI

Showing blogs 1-4 (out of 4)

Using the CalendarAuto function effectively in Power BI

Posted by Andy Brown on 24 November 2021

This blog shows how to generate a table which includes not only all of the dates in your data model, but also a range of aggregator columns such as financial year and month name for reporting purposes.

Creating complex custom date periods in calendar tables using calculated columns

Posted by Sam Lowrie on 17 May 2019

This blog shows how to create custom date periods within a date table for 28 day cycles, but the principles shown could be applied to create any custom date periods.

Creating a calendar or date table in Power BI using built-in calendar functions

Posted by Sam Lowrie on 17 May 2019

Learn how to create a basic date table in Power BI, using either the CALENDAR or CALENDARAUTO functions, and also learn how to then add custom columns of your own.

Modelling a fixed or variable custom financial year in Power BI

Posted by Sam Lowrie on 17 May 2019

Whether your financial year ends on a fixed date every year or on the first Monday in June, this blog will show you how to incorporate it into your calendar table.

This page has 0 threads Add post