topic Re: Extract dimensional data with for last date value in Power Query

Extract dimensional data with for last date value

joshua1990 — Fri, 30 Jun 2023 11:52:11 GMT

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?

Re: Extract dimensional data with for last date value

AlienSx — Fri, 30 Jun 2023 12:13:43 GMT

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

Re: Extract dimensional data with for last date value

joshua1990 — Sat, 01 Jul 2023 09:28:20 GMT

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

Is there any other approach to get this achieved?