How to optimize the Dax expression to get last date refresh

[Anonymous]

Please I wanted to optimize the dax below because it is running slow.

Data Source  = 

SWITCH ( TRUE ()
, Max(ReturnOrder[Date]) < TODAY()-1 || Max(Sales[Date]) < TODAY()-1, "Yesterday's data missing for: " &
SWITCH ( TRUE ()
, Max(ReturnOrder[Date]) < TODAY()-1 , "ReturnOrder" & ", ", BLANK() )
&
SWITCH ( TRUE ()
, Max(Sales[Date]) < TODAY()-1 , "Sales" & ", ", BLANK() )
, BLANK() )

 Thanks 

[v-kelly-msft · Accepted solution]

Hi  @Anonymous ,

Try:

Data Source =
IF (
    MAX ( ReturnOrder[Date] )
        < TODAY () - 1,
    "Yesterday's data missing for: " & "ReturnOrder" & ", ",
    IF (
        MAX ( 'Sales'[Date] )
            < TODAY () - 1,
        "Yesterday's data missing for: " & "Sales" & ", ",
        BLANK ()
    )
)

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Anonymous , Try something like

measure =
var _max1 =MaxX(allselected(ReturnOrder),ReturnOrder[Date])
var _max1 =MaxX(allselected(Sales),Sales[Date])
return
max(_max1,_max)

or

measure =
var _max1 =MaxX(allselected(ReturnOrder),ReturnOrder[Date])
var _max1 =MaxX(allselected(Sales),Sales[Date])
return
if(_max1>_max,_max1, _max)