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      
        
Super User IV
Super User IV

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 IV
Super User IV

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/
Highlighted
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
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors