Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
104 | |
85 | |
73 |