Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to pull data from a table from spesific date?

Hi all,   I use ODBC to connect to a table. The table contains many rows (more then I need). How can I get data from the table after a specific date without pulling all table before?   Thanks,
Need Help
dax's avatar
dax
Community Support
6 years ago

Hi Anonymous , 

You could try to use M code like below to filter data

= Table.SelectRows(#"Changed Type", each [Column1] <=#date(2020,5,19))

 

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.