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. I...
Need Help
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