Max date of column based on 2 columns

[PowerBITestingG]

Hi all,

Got 3 columns and I need to a new column that returns the max of Date that is between Max Fiscal Date and Min Fiscal date. Any ideas?

Date	Max Fiscal Date	Min Fiscal Date	New Max Date
14/09/22	28/09/22	1/09/22	14/09/22
14/10/22	30/10/22	29/10/22	18/10/22
18/10/22	30/10/22	29/10/22	18/10/22

Thank you

[speedramps · Accepted solution]

Hi PowerTestingG

Please consider this solution.

When I have helped you, please help me with kudos.

Click the thumbs up if you like me trying to help you.

And click Accept As Solution if I have fixed your problem.

One problem per ticket please.
If you need to expand or change your problem then please accept this solution and raise a new ticket.

New max date =

CALCULATE(

MAX('Table'[Date]),

ALLEXCEPT('Table','Table'[Min Fiscal Date])
)