Min and max comparing to 2 columns

[Anonymous]

Hi Team,

I have 4 date columns I need to display min and max.

Min Date : I want to look if "actula start date" has date pick the min or if it is blank then look the value from "Planned Start Date".

Max Date : Similar as Min date but columns are "Planned Closed Date" &  "Actual Closed Date".

Here is my data. 

My out look is :

Min Date : 1/1/2020

Max Date : 1/6/2021

Project	Sub Project	Planned Start Date	Planned Closed Date	Actual Start Date	Actual Closed Date
A	AA	1/12/2020	1/12/2021	1/2/2021
A	AB	1/1/2020	1/6/2020	1/4/2020	1/10/2020
A	AC	1/6/2021	1/12/2021
B	BA	1/5/2021	1/12/2021
B	BB	1/4/2020	1/6/2020	1/6/2020	1/8/2021
B	BC	1/3/2021	1/5/2021	1/4/2021	1/6/2021

[vanessafvg]

you could do something like this

mindate =
IF (
    ISBLANK ( [actual start date] ),
    min([planned Start Date]),
    min([actual start date])
)

you can do similar for the max date

[selimovd · Accepted solution]

Hey @Anonymous ,

you can do that with a measure like that:

Min Date = IF( MIN( 'Table'[Actual Start Date]) <> BLANK(), MIN( 'Table'[Actual Start Date] ), MIN( 'Table'[Planned Start Date] ) )

Similar then for the MAX.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic