Forum Discussion

Helper II

7 years ago

Solved

Find the min and max date

Hi i have a very basic question that I am stuck on. I have 2 columns from the same table. Customer Date Customer Date 1 2/2/2018 2 2/6/2018 3 2...

7 years ago

You may create a column like below:

Column =
IF (
    'Table'[Date] = MAX ( 'Table'[Date] ),
    "MAX",
    IF ( 'Table'[Date] = MIN ( 'Table'[Date] ), "MIN", BLANK () )
)

Regards,

Helper II

7 years ago

Anonymous

Hey I am not sure why I am not getting the right answer. What am I doign wrong here?

Is Latest Row Filter =

VAR LatestDate = MAXX(FILTER(Billing,Billing[Bill Date] = EARLIER(Billing[Bill Date)),Billing[Bill Date)

RETURN IF(Billing[Bill Date=LatestDate,1,0))))

Max =

VAR LatestDate =

CALCULATE ( MAX ( Billing[Bill Date] ), ALL ( Billing ) )

RETURN

IF ( MIN ( Billing[Bill Date] ) = LatestDate, 1, 0 )

Microsoft Employee

7 years ago

You may create a column like below:

Column =
IF (
    'Table'[Date] = MAX ( 'Table'[Date] ),
    "MAX",
    IF ( 'Table'[Date] = MIN ( 'Table'[Date] ), "MIN", BLANK () )
)

Regards,