Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 2013 Power Query

Status
Not open for further replies.
pat718

pat718

Programmer
Joined
Apr 21, 2014
Messages
12
Location
US
I am trying to calculate a minimum value using Power Query. The MIN that can be used in Excel does not work in Power Query. Can some one help me?

Thanks.
 
Sort by date Sort by votes
Hi,

Can you explain exactly what you're trying to do and how you're trying to do it.
 
Upvote 0 Downvote
Hi,

I have different ages of insurance customers. I need to get the minimum age of a group of customers from a specific insurance carrier. I hope that makes sense. There are several insurance carries that contract out to several "companies" in order to decide what insurance premium should a insurance carrier should quote a potential customer.
 
Upvote 0 Downvote
HOW are you attempting to do whatever you are doing, with "Power Query
 
Upvote 0 Downvote
Yes, with Power Query. What formula do I need for getting the minimum value in a column. The MIN that is used in Excel does not work.
 
Upvote 0 Downvote
Please post the SQL that you are using.

What is the data source and what kind of data source is this?
 
Upvote 0 Downvote
I don't have anything to post. I am simply trying to get the formula for deriving the minimum value in Power Query.
 
Upvote 0 Downvote
I don't know. If Table.Min will work to get a minimum value than I guess so. I just don't know how to get the minimum value in Power Query.
 
Upvote 0 Downvote

Getting relevant data from you is like pulling teeth!!!

You NEVER yet revealed the source of your data (access, excel, oracle, db2 etc)
 
Upvote 0 Downvote
SkipVought,

I don't know how to be more clear. I said that I am trying to calculate a minimum value in Excel Power Query. Of course, the data is Excel. I am just trying to get the minimum values of a column of ages. If you need anymore clarification than that then just don't respond. Perhaps someone else can assist me with my SIMPLE request.
 
Upvote 0 Downvote
Why are you using Power Query to calculate an aggregation in, what, this workbook or another workbook?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question Question
Excel Power Query refresh error
Replies
3
Views
2K
SoftwareRT
SoftwareRT
M
  • Locked
  • Question Question
Excel Power Query
Replies
4
Views
1K
combo
combo
Snirt
  • Locked
  • Question Question
MS-Office 2013 Excel Issue
Replies
1
Views
610
SkipVought
S
remeng
  • Locked
  • Question Question
Power Query Split by Table Group by Rows into a new set of group by tables
Replies
2
Views
743
remeng
remeng
Swi
  • Locked
  • Question Question
Excel Webservice
Replies
2
Views
811
mintjulep
M

Part and Inventory Search

Sponsor

Back
Top