Forum Discussion
filter - last 14 days
Hello,
I want to filter in a table in POWER QUERY the date column to have only the data of the last 14 days.
I have tried to put the following:
= Table.SelectRows (_Data_sales, each [Date_Invoice]> = # DDateTime.LocalNow () - 14)
but it gives me error.
Looks like your column in in DateTime format. Let's convert it then. Try this:
= Table.SelectRows (_Data_sales, each Number.From(Date.From(DateTime.LocalNow()) - Date.From([Date_Invoice])) <=14 )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
4 Replies
Hi yousseftb
It always helps to paste here the exact error message you get. Try this:
= Table.SelectRows (_Data_sales, each Number.From(Date.From(DateTime.LocalNow()) - [Date_Invoice]) <=14 )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Helo, many tanks for your message.
When I put your code I get this error:
Expression.Error: We cannot apply operator - to types Date and DateTime.
Details:
Operator=-
Left=05/06/2020
Right=07/01/2019 00:00:00
any suggestion ?
Looks like your column in in DateTime format. Let's convert it then. Try this:
= Table.SelectRows (_Data_sales, each Number.From(Date.From(DateTime.LocalNow()) - Date.From([Date_Invoice])) <=14 )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
