Forum Discussion

SkorpionAAM's avatar
SkorpionAAM
Helper V
4 years ago
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'[layername] ,'mms Statistics'[Expected]),[Expected])
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

10 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    4 years ago

    Please provide sample data and a depiction of the expected output to help us understand what you need and provide a working solution.

    • SkorpionAAM's avatar
      SkorpionAAM
      Helper V
      4 years ago

      I want Unique value of latest Date group by Layname,Run Name Segmenr and Latest Date .. 

       

      I can share the Power Bi File If you want please let me can i share the file on Google Drive>>

       

      How can i share Sample data Or Power BI file

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi SkorpionAAM 

     

    Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

     

    Best Regards,
    Eyelyn Qin