SOLVED

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

Frequent Contributor

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 Replies
best response confirmed by small_village (Frequent Contributor)
Solution

@small_village 

 

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

@alannavarro 

Thank you very much.

It's actually worked 100%.

Regards,

Tuan.