Forum Discussion
Solved
How can get the expected table value for each days using Power Query.
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...
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.
https://learn.microsoft.com/en-us/powerquery-m/excel-currentworkbook
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.
https://learn.microsoft.com/en-us/powerquery-m/excel-currentworkbook
