Forum Discussion
the date operation failed because the resulting value falls outside the range of allowed values
Hello, I used the follow power query not issue: = Table.SelectRows(Intercept, each [Name]>= #date( Date.Year(Date.From("2023/12/31")),Date.Month(Date.From("2023/12/31"))-2,1) and [Name] <= D...
What are you trying to accomplish with that query?
thanks for your reply.
let me explain the whole picture.
my user share lots of excel file in sharepoint, the file name format like ' ****************_YYYYMMDD.xlsx'
I need to consolidate the last 3 month's.
for example,
For January, include October, November and December 's file.
For Febuary, include November ,December and January 's file. thanks!
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.its sample, thanks.