Date filter with specified periods

Hi Casper,

I'd recommend working with a dimDate table (table containing one row for every date) for date analyses. There you can add calculated columns with custom definitions such as periods based on accounting periods. Once you have a dimDate table you could add the periods from your accounting periods table to this table with DAX. Below you'll find an example of how I added a column with customized periods to a dimDate table, based on an existing table containing accounting periods: 

Existing accounting periods table:

Accounting periods

Adding Accounting periods to dimDate:

result when using in visuals:

Hope that helps you getting started

Groetjes,

Tim