Create a calculated column to show the minimum date filtering on another column in the same table

[User7664]

Hi

I have a date table (below) and im trying to create a column to show the minium date for previous period '-2' and for '-1', and for '0' etc etc. 

In excel it would be minifs(date,previous period=previous period). See below.

[Fowmy · Accepted solution]

@User7664 

Add the following column:

Column = 

CALCULATE(
    MIN( ActualDateRange[Date] ),
    ALLEXCEPT(ActualDateRange , ActualDateRange[Previous Period] )
)