How to get the earliest week and latest week when fact and date table are both present

[FOXYBARK]

Sample Data 

I have 1 Fact table and 1 Date table. I would like 2 new metrics. 

Earliest week of = 

Latest week of = 

Both metrics should be based on the orders in the Fact table, not the Date table. I'm still learning. 

Thanks

[DataInsights · Accepted solution]

@FOXYBARK,

Try these measures:

Earliest Week Of = 
VAR vMinFactDate =
    CALCULATE ( MIN ( 'FACT'[DATE] ), ALL ( 'FACT' ) )
VAR vTable =
    FILTER ( ALL ( 'DATE' ), 'DATE'[DATE] = vMinFactDate )
VAR vResult =
    MAXX ( vTable, 'DATE'[WEEK OF] )
RETURN
    vResult

Latest Week Of = 
VAR vMaxFactDate =
    CALCULATE ( MAX ( 'FACT'[DATE] ), ALL ( 'FACT' ) )
VAR vTable =
    FILTER ( ALL ( 'DATE' ), 'DATE'[DATE] = vMaxFactDate )
VAR vResult =
    MAXX ( vTable, 'DATE'[WEEK OF] )
RETURN
    vResult