Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
SkorpionAAM
Helper V
Helper V

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])
1 ACCEPTED SOLUTION
v-eqin-msft
Community Support
Community Support

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.

View solution in original post

10 REPLIES 10
v-eqin-msft
Community Support
Community Support

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

v-eqin-msft
Community Support
Community Support

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.
PaulDBrown
Community Champion
Community Champion

You can share the PBIX from Google Drive for example. 
Also check out this thread to see if it helps:

https://community.powerbi.com/t5/Desktop/MAX-date-by-group/m-p/2342732#M845015 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






any luck ???

Sorry but which unique value do you wish to calculate and what visual are you placing it in? Please provide a depiction of the visual

At a guess:

Latest value.jpg





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






i tred this but no success

PaulDBrown
Community Champion
Community Champion

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





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






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

SkorpionAAM
Helper V
Helper V

aNYONE  Please 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors