Date Filter With Overlapping Dates

[Anonymous]

I am trying to create a slicer that allows you to push a button to select a specific date range. There will need to be overlapping date ranges so the most recent date will be shown as part of Yesterday, This Month and This Week.

At the moment I have created a custom table that sets a label to a date, but I can't get the system to filter the Calender table based on the Date Reference as this is a One to Many relationship that is constantly being swapped to a Many to One relationship so I can either filter in the wrong direction or run the filter in both directions.

Is there a way to get the system to do a single direction filter on a One to Many relationship, or am I approaching this in completely the wrong way and there is a better system to create the filter I want?

[DataInsights · Accepted solution]

@Anonymous,

A calculation group would be a good option. You could create five calculation items, one for each slicer value. Here's an article on how to create them:

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-the-model-explorer-with-calculation-group-authoring-and-creating-relationships-in-the-properties-pane/ 

[Anonymous]

Thanks,

I didn't know that calculation tables existed. They are exactly what I was looking for.