Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Min and max comparing to 2 columns

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"....
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    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
     
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
5 years ago

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