How to select a date range that's not in the future based on an end date?

[singleton2787]

How would you select the current Sprint (based on today's date) and NOT select the future dates? I've tried Calendar MINX and MAXX, but it selects future dates as well. It's almost like you need to have a function that uses today() but no more than X days in the future (the end of the sprint) thus removing future Sprints. I could use the IterationPath as a slicer?

[v-yueyunzh-msft]

Hi, @singleton2787 

According to your description , you want to filter the Springs which the [EndDate] is before the TODAY().And you want to get the [IterationPath] in this condition. Right?

Here are the steps you can refer to :
(1)This  is my test data :

(2)You can click "New Table" to create a table in Power BI Desktop:

Table = FILTER( 'Tabelle1' , 'Tabelle1'[EndDate] <= TODAY())

(3)You can put the [IterationPath] field in your slice and you can also create a relationship between two tables :

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[singleton2787]

How do I get the dates right?

[v-yueyunzh-msft · Accepted solution]

Hi , @singleton2787 

What do you want to show in this visual . It looks like that you have only one [Start Date] and [End Date] . 

My test result is as follows:

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly