Forum Discussion

User7664's avatar
User7664
Icon for Helper I rankHelper I
4 years ago
Solved

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

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.

 

 

Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    User7664 

    Add the following column:

    Column = 

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

1 Reply

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    4 years ago

    User7664 

    Add the following column:

    Column = 

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