Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Purushothaman
Partner - Creator III
Partner - Creator III

Min and Max for Last_year_Quarter and Last_year_half

Hi All,

How to find the min and Max value for  Last_year_Quarter and Last_year_half on the below data set:

Purushothaman_0-1653381735695.png

Anyone, Please help!! 

Thank you!

1 Solution

Accepted Solutions
Andrei_Cusnir
Specialist
Specialist

Hello,

 

You can use Min(last_yearquarter) and Min(last_yearhalf), unless I have misunderstood the use case scenario. 

 

On my side I have the following dataset and the outcome:

 

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members. 
 

Help users find answers! Don't forget to mark a solution that worked for you! 🙂

View solution in original post

1 Reply
Andrei_Cusnir
Specialist
Specialist

Hello,

 

You can use Min(last_yearquarter) and Min(last_yearhalf), unless I have misunderstood the use case scenario. 

 

On my side I have the following dataset and the outcome:

 

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members. 
 

Help users find answers! Don't forget to mark a solution that worked for you! 🙂