Differences in using dates from FACT TABLE and DIMENSION TABLE

Hi,

Please find attached the PBI file.

Hope this helps.

inmingoon I believe this is what you are looking for, basically, you need to work with the date table in each expression:

Max PRICE = 
VAR SLT_DAT = MAX ( 'Date'[DATE] )
VAR SUM_TBL = SUMMARIZE ( 'DATA', 'SYMBOL'[NAME] )
VAR PRC_DAT = 
CALCULATE ( 
    MAX ( 'PRICE'[DATE] ),
    FILTER ( 
        ALLSELECTED ( 'DATE'[Date] ),
        'DATE'[DATE] <= SLT_DAT
    ), 
    SUM_TBL
)
VAR result = 
CALCULATE (
    MAX ('PRICE'[PRICE] ),
    SUM_TBL, 
    'Date'[DATE] = PRC_DAT
)

return result 

inmingoon you can also take advantage of the LASTNONBLANKVALUE function, Check the video here LASTNONBLANKVALUE and Missing Data - Power BI - YouTube

Max PRICE 2 = 
VAR SUM_TBL = SUMMARIZE ( 'DATA', 'SYMBOL'[NAME] )
VAR result = 
CALCULATE (
    LASTNONBLANKVALUE ( 'Date'[DATE], SUM ( 'PRICE'[PRICE] ) ),
    SUM_TBL, 
    FILTER ( 
        ALLSELECTED ( 'DATE'[Date] ),
        'DATE'[DATE] <= MAX ( 'DATE'[DATE] )
    )
)

return result