Avatar of Karen Emch
Karen Emch
 asked on

Group by Issues with date field when using power query

Hello,

I am having trouble grouping by date when using power query to import data from an excel file.  The group by option is grayed out.  If I open the excel file and create a pivot table with the data directly the group by date option is available which leads me to believe that the problem is not with the data in the date field.

I will have updated data regularly and want to use power query to create a link so that I can create a pivot table one time rather than having to create a new pivot table each time I export data.

Any help would be greatly appreciated.

thanks
Microsoft Excel

Avatar of undefined
Last Comment
Subodh Tiwari (Neeraj)

8/22/2022 - Mon
Tom Farrar

What do you mean you are having trouble with the grouping in the power query/pivot?  Can you provide an example file?
ASKER CERTIFIED SOLUTION
Subodh Tiwari (Neeraj)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Jerry Paladino

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Karen Emch

ASKER
Thanks for everyone's input.   I was loading to the data model as I'd like to add some formulas using DAX.  I am new using power pivot and power query and had completely forgotten about having to add the calendar.   For now I'll use power query to load to a table until I can refresh my memory on how to properly add the calendar.   I'll just have to add the calculated column outside the pivot table for now.  It should be an okay work around.

Thanks again for everyone's help.

Karen
Subodh Tiwari (Neeraj)

You're welcome Karen! Glad we could help.
Your help has saved me hundreds of hours of internet surfing.
fblack61