Compare measure

[ziomalski]

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?

[tamerj1]

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]

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