Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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!

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    its sample, thanks.

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      in a usable format please, not as a screenshot

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        for example, there are lots excel file in share point, format is ***_YYYYMMDD.xlsx.

        ABC_20230901.xlsx

        ABC_20230911.xlsx

        ABC_20230921.xlsx

        ABC_20230923.xlsx

        ABC_20231001.xlsx

        ABC_20231011.xlsx

        ABC_20231021.xlsx

        ABC_20231024.xlsx

        ABC_20231031.xlsx

        ABC_20231104.xlsx

        ABC_20231114.xlsx

        ABC_20231124.xlsx

        ABC_20231128.xlsx

        ABC_20231204.xlsx

        ABC_20231214.xlsx

        ABC_20231224.xlsx

        ABC_20240104.xlsx

        ABC_20240114.xlsx

        ABC_20240124.xlsx

        ABC_20240131.xlsx

        I need to consolidate the last 3 month's file.

        for January, need consolidate from ABC_20231001.xlsx to ABC_20231224.xlsx (from October to December);

        for Febuary, need consolidate from ABC_20231104.xlsx to ABC_20240131.xlsx (from November to January)c.

        thanks.

Related content