How can get the expected table value for each days using Power Query.

[littlevillage]

Hi,

How can get the expected table value for each days using Power Query. I have the values of the last four days, i just only want to get the last three days of them. I try to use Append Queries to approach that. But I don't know exactly how to get the last three days.
Can you give me some advices.
Thank you.

[#2 · Accepted solution]

@littlevillage 

You can use Excel.CurrentWorkbook() and it is going to bring all the tables that you have in the workbook. Then you could just filter or another solution was to group by date, then sort in ascending order and filter for the bottom 3 rows.

Excel.CurrentWorkbook - PowerQuery M | Microsoft Learn

[#3]

@alannavarro 

Thank you very much.

It's actually worked 100%.

Regards,

Tuan.