Creating calendar tables with DAX using Power BI
April 6th, 2020 in Blog, Business Intelligence, Dashboarding and Reporting, Power BIBy Nick Edwards In this blog post we’ll take a quick look at creating a self-generating calendar table using DAX. Dates are important if we want to perform time intelligence reporting on our data i.e. yearly sales, monthly sales, weekly sales, year to date sales or previous year sales. We’ll be using the calendar function to create our date table, but there are other methods to do this such as CALENDARAUTO or GENERATESERIES. Here is the…
» Read more