Extract dimensional data with for last date value

[joshua1990]

Hi experts!

I have a report that saves every week some dimensional data. It's like 30 columns for each article and every week.

It happens that a article is removed from one week to another etc. It happens also that some of the master data changes over time.

Now I would like to extract for each article the master data with the latest entry based on the date column.

Article

Attribute 1

Attribute n

Date

How would you do this in Power Query?

[joshua1990]

@AlienSx : Thanks a lot. But your approach takes 2h within PQ.

Is there any other approach to get this achieved?

[AlienSx]

Hi, @joshua1990 

let
    Source = your_table,
    names = List.Buffer(List.RemoveItems(Table.ColumnNames(Source), {"Article"})),
    group = Table.Group(Source, {"Article"}, {{"all", each Table.Max(_, "Date")}}),
    expand = Table.ExpandRecordColumn(group, "all", names)
in
    expand