Forum Discussion

jerryr0125's avatar
jerryr0125
New Member
10 months ago
Solved

Power Query - Keep Rows based upon maximum date?

Hi - I know there is a command in Power Query to 'keep rows', but is there a way to keep specific rows based upon the maximum date in the table ? Example - transactiontable - start   Date Tra...
Show and Tell
Tips and Tricks
  • Nasif_Azam's avatar
    Nasif_Azam
    10 months ago

    Hey jerryr0125 ,

     

    Use the following M code that should full fill your requirements:

    let
    Source = transactiontable,
    MaxDate = List.Max(Source[Date]),
    FilteredRows = Table.SelectRows(Source, each [Date] = MaxDate)
    in
    FilteredRows  

     

    Result:

     

    Also check the attached pbix file.

     

     

    Best Regards,
    Nasif Azam

     

v-aatheeque's avatar
v-aatheeque
Icon for Community Support rankCommunity Support
10 months ago

Hi jerryr0125 

Just checking in to see if the previous responses helped resolve your issue. If not, feel free to share your questions and we’ll be glad to assist.

v-aatheeque's avatar
v-aatheeque
Icon for Community Support rankCommunity Support
10 months ago

Hi jerryr0125 

We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.