cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
howarbo Frequent Visitor
Frequent Visitor

Re: Getting Quantity related to Max and Min Price

Data Example       
ProductInvoicePrice/GalQtyYearPeriod  
Jet Fuel 10902464.8177020195  
Jet Fuel 10902474.1710020195  
Jet Fuel 10902483.99820020195  
Jet Fuel 10902493.95930020195  
Jet Fuel 10902504.8140020195  
Jet Fuel 10902514.8150020195  
Jet Fuel 10902523.95910020195  
Jet Fuel 10902533.95920020195  
        
        
        
Expected Results      
Max Price4.81      
Min Price3.959      
Qty Max Price1270      
Qty Min Price600      
        
Highlighted
Super User
Super User

Re: Getting Quantity related to Max and Min Price

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
howarbo Frequent Visitor
Frequent Visitor

Re: Getting Quantity related to Max and Min Price

Thank you! Thank you!

Super User
Super User

Re: Getting Quantity related to Max and Min Price

Hi,

If my reply helped, please mark it as Answer.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
howarbo Frequent Visitor
Frequent Visitor

Re: Getting Quantity related to Max and Min Price

I don't see icon or way to mark is as Answer.  Do I just write "Answer"?

If so, then your reply was the Answer.Smiley Happy

I also put it in the tag.....

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,132)