Forum Discussion

joshua1990's avatar
joshua1990
Post Prodigy
3 years ago

Extract dimensional data with for last date value

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?

Need Help

2 Replies

  • AlienSx's avatar
    AlienSx
    Super User
    3 years ago

    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
  • joshua1990's avatar
    joshua1990
    Post Prodigy
    3 years ago

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

    Is there any other approach to get this achieved?