Forum Discussion

ziomalski's avatar
ziomalski
New Member
3 years ago

Compare measure

Hi,

how to solve the problem.

Reservations for the defined period are inflowing into the table (incrementially). I'm generating every week a file with fullfiled reservations. I want to see how many reservations were made since last file.

I want to compare every time how many reservations were made from the date of generated file. I can make measure "last 7 days" but when i want to see it next days 7 days will be count from today.

 

file 1 is generated on 1.4.2023 and has 10 rows

file 2 is generated on 8.04.2023 and has 20 rows

 

Files are written into speficic folder, then the folder goes to the Power Query. I thought the generated day of the file could be helpful  but i can't solve this. thank you for your answers how could it be solved?

2 Replies

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi ziomalski 
    I'm not sure if there is a way to get Power Query to display attribute columns for folders. As far as I know it shows only the attributes of files. Perhaps wdx223_Daniel has a better answer to this query.

    • wdx223_Daniel's avatar
      wdx223_Daniel
      Icon for Community Champion rankCommunity Champion
      3 years ago

      Thanks tamerj1 

      ziomalski if you want get the file's generated date, you can bring in the filed value of "Date created" by the function of Folder.Files.

      let

          Source=Folder.Files("your folder path"),

          Coustom1=Table.Combine(Table.TransformRows(Source,each Table.AddColumn(Excel.Workbook([Content])[Data]{0},"Generated Date",(x)=>[Date created])))

      in

         Custom1