Solved: Create a calculated column to show the minimum dat...

User7664 · ‎10-25-2021

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 · ‎10-25-2021

@User7664

Add the following column:

Column = 

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

Did I answer your question? Mark my post as a solution! and hit thumbs up

Fowmy · ‎10-25-2021

@User7664

Add the following column:

Column = 

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

Did I answer your question? Mark my post as a solution! and hit thumbs up

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