Forum Discussion
filter - last 14 days
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
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
Many thanks, it s work