Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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!
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!
@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)