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...
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