Forum

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...

let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Grouped Rows" = Table.Group(Source, {"District"}, {{"Data", each _, type table [Dist...

How about loading a sample workbook showing what you have and then mock up what you expect the results to look like. We can then analyze and provide ...

if Text.StartsWith([Our Ref_1],{0..9}) then [Our Ref_1] else null))) try this