Date Measure: Earliest Date in selection

[sindrekb]

Hi, 

Please refer to included snip. I'm looking to create a measure that returns at all times the earliest date in a selection. As seen below, my current measure - Measure Earliest Date - returns the earliest date for each category (FYP - fiscal year period). This should ideally project 31.01.2022 in this case (which refers to FYP 2022AP01) in this case. 

The measure should also be dynamic in such a way that if I narrow the selection to 2023 onwards, the measure "Measure Earliest Date" projects 31.01.2023, referring to FYP 2023AP01. 

[LuizKoller]

Hello @sindrekb 

Can you provide some visual of the datamodel?

It probably ll help using:

RETURN
CALCULATE(

 _minDate,
 CROSSFILTER('TableA'[RelatedColumn], 'TableB'[RelatedColumn], Both)

)

[sindrekb]

Update: I changed the Measure to use the formula "Firstdate" and tried to supplement with "Keepfilters". For the selection below (2023AP05 onwards), "Measure Earliest Date" should return 31.05.2023 rather than 31.01.2022.