Forum Discussion

User7664's avatar
User7664
Icon for Helper I rankHelper I
5 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 per...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    User7664 

    Add the following column:

    Column = 

CALCULATE(
    MIN( ActualDateRange[Date] ),
    ALLEXCEPT(ActualDateRange , ActualDateRange[Previous Period] )
)
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

User7664 

Add the following column:

Column = 

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