Forum

The date time column is coming over as European as dd/mm/yy hh:mm AM or PM What do you want the data to look like? I can convert it to US format i...

Here is what Microsoft suggests

Highlight your table and click on Add to Data Model and click on refresh all. Same as you would in a regular Pivot Table. Make sure you are in Power...

Thought this might be beneficial

Will you mock up what the expected PT should look like. I am not visualizing what you want. That will help to determine what we need to do to get th...

Sorry about the attachment. Attached now.

Bring your data into a Data Model and write a measure to consolidate the data separated by commas. See my attached file. A tutorial on this is at:

Here is a white paper that will help you as you go forward.

In my mind, if you have a data base then you should be using Data Base Software (ie. MS Access) as spreadsheets are really not the most effective way...

Look at the attached. All done with Power Query let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Grouped Rows" = Table.Group(Sour...

I used Power Query let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Grouped Rows" = Table.Group(Source, {"Old Consumer Id"}, {{"Da...

Where is the source data? This might be possible with Power Pivot, but cannot access the source data of the existing PT. Possible to build a measure...

Group your data and keep all rows. Call the new grouped column "Data" Add a column =Table.AddIndexColumn([Data],"Index",1,1) Delete the grou...

Have you tried. ActiveWorkbook.RefreshAll

Try this Mcode let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], CheckColors = Table.AddColumn(Source, "Custom", each if[Colors]="Gre...