Forum Discussion
Solved
Need maxx
I have function i need to add max date in this function i tried but getting error UNQExpected = sumx(Summarize('mms Statistics', 'mms Statistics'[run_name_segement] ,'mms Statistics'[layernam...
Hi SkorpionAAM ,
If you want to get the maximum [Expected] of each 'mms Statistics (2)'[run_name_segement]) and 'mms Statistics (2)'[layername] ? If so , please try:
MAXX = MAXX(FILTER(ALL('mms Statistics (2)'),[run_name_segement] =MAX('mms Statistics (2)'[run_name_segement]) && [layername] =MAX('mms Statistics (2)'[layername])),[Expected])If not, can you please share more detail information about the logic of MAX to help us clarify your scenario?Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
aNYONE Please